| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return file from a path string
If you have xl2000 or later:
sStr = "C:\folder1\folder2\folder3\folder4\folder5\file.x ls" ? Right(sStr,len(sStr)-instrrev(sStr,"\")) file.xls demo's from the immediate window. -- Regards, Tom Ogilvy "Steph" wrote in message ... I have a string variable that is a path to a file: C:\folder1\folder2\folder3\folder4\folder5\file.xl s How can I create a new variable that is simply the file name.xls? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return file from a path string
Thank you so much
"Tom Ogilvy" wrote in message ... If you have xl2000 or later: sStr = "C:\folder1\folder2\folder3\folder4\folder5\file.x ls" ? Right(sStr,len(sStr)-instrrev(sStr,"\")) file.xls demo's from the immediate window. -- Regards, Tom Ogilvy "Steph" wrote in message ... I have a string variable that is a path to a file: C:\folder1\folder2\folder3\folder4\folder5\file.xl s How can I create a new variable that is simply the file name.xls? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate path and file string for external reference | Excel Worksheet Functions | |||
| How to extract only file name from folder path string in Excel? | Excel Worksheet Functions | |||
| Recursive Function + File searching to return path | Excel Programming | |||
| Stripping Path from File String | Excel Programming | |||
| Using a variable string in a file save path | Excel Programming | |||
Linear Mode
