Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to extract file name from path?

Tags:

string

vba

How do I extract the filename myfile.pdf from C:\Documents\myfile.pdf in VBA?

like image 290
Johan Avatar asked Nov 16 '09 16:11

Johan


People also ask

How do I separate the filename and path in Python?

split() method in Python is used to Split the path name into a pair head and tail. Here, tail is the last path name component and head is everything leading up to that. In the above example 'file. txt' component of path name is tail and '/home/User/Desktop/' is head.

Does a file path include the name?

Paths include the root, the filename, or both. That is, paths can be formed by adding either the root, filename, or both, to a directory.


2 Answers

The best way of working with files and directories in VBA for Office 2000/2003 is using the scripting library.

Create a filesystem object and do all operations using that.

Early binding:

Add a reference to Microsoft Scripting Runtime (Tools > References in the IDE).

Dim fso as new FileSystemObject Dim fileName As String fileName = fso.GetFileName("c:\any path\file.txt") 

Late binding (see comments for more)

With CreateObject("Scripting.FileSystemObject")     fileName = .GetFileName(FilePath)     extName = .GetExtensionName(FilePath)     baseName = .GetBaseName(FilePath)     parentName = .GetParentFolderName(FilePath) End With 

The FileSystemObject is great. It offers a lot of features such as getting special folders (My documents, etc.), creating, moving, copying, deleting files and directories in an object oriented manner.

like image 157
Zen Avatar answered Sep 30 '22 08:09

Zen


Dir("C:\Documents\myfile.pdf") 

will return the file name, but only if it exists.

like image 29
Dick Kusleika Avatar answered Sep 30 '22 08:09

Dick Kusleika