Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Filename
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Filename
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Filename
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) "Jarle" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Filename
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: C:\Documents and Settings\Folder1\Folder2\....\filename How can I easily load only the filename to the variable f_name? rgds Jarle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return filename | Excel Programming | |||
SaveAs Filename:=filename, FileFormat:=xlCSV | Excel Programming | |||
Converting a Variable Filename to a Constant Filename | Excel Programming | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Function to return filepath given full filename | Excel Programming |