Return Filename

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jarle - 03 Mar 2008 21:01 GMT

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

Reply to this Message

IanKR - 03 Mar 2008 21:25 GMT

>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?

What you've got there is ThisWorkbook.FullName. To get just the file name
use ThisWorkbook.Name and assign that to f_name.

Reply to this Message

Bob Phillips - 03 Mar 2008 21:36 GMT

If you need to parse it, look at InstrRev in VBA help.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have the string that includes path and filename:
>
[quoted text clipped - 4 lines]
> rgds
> Jarle

Reply to this Message

Jarle - 04 Mar 2008 07:45 GMT

I did it like this:

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

Jarle skrev:

> I have the string that includes path and filename:
>
[quoted text clipped - 4 lines]
> rgds
> Jarle

Reply to this Message