Return Filename

  • Thread starter Thread starter Jarle
  • Start date Start date
J

Jarle

I have the string that includes path and filename:

C:\Documents and Settings\Folder1\Folder2\....\filename

How can I easily load only the filename to the variable f_name?

rgds
Jarle
 
I have the string that includes path and filename:
C:\Documents and Settings\Folder1\Folder2\....\filename

How can I easily load only the filename to the variable f_name?
Click to expand...

What you've got there is ThisWorkbook.FullName. To get just the file name
use ThisWorkbook.Name and assign that to f_name.
 
If you need to parse it, look at InstrRev in VBA help.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I did it like this:

s = "C:\Documents and Settings\folder1\folder2\bok2.xls"
s1 = Split(s, "\")
f_name = s1(UBound(s1))


Jarle skrev:
 
Back
Top