| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I determine the file path with the file name at the end
This gets me the file name but need the path seperate
Path = Left(ActiveWorkbook.FullName, Len(ActiveWorkbook.FullName) - _ InStrRev(ActiveWorkbook.FullName, Application.PathSeparator)) -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I determine the file path with the file name at the end
MsgBox ThisWorkbook.Path & vbCrLf & ThisWorkbook.Name
-- HTH... Jim Thomlinson "QuietMan" wrote: This gets me the file name but need the path seperate Path = Left(ActiveWorkbook.FullName, Len(ActiveWorkbook.FullName) - _ InStrRev(ActiveWorkbook.FullName, Application.PathSeparator)) -- Helping Is always a good thing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I determine the file path with the file name at the end
thanks
-- Helping Is always a good thing "Jim Thomlinson" wrote: MsgBox ThisWorkbook.Path & vbCrLf & ThisWorkbook.Name -- HTH... Jim Thomlinson "QuietMan" wrote: This gets me the file name but need the path seperate Path = Left(ActiveWorkbook.FullName, Len(ActiveWorkbook.FullName) - _ InStrRev(ActiveWorkbook.FullName, Application.PathSeparator)) -- Helping Is always a good thing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Windows API to Determine if File is Local/Convert Path to Drive Letter | Excel Programming | |||
| Determine if XL file opened from Outlook or a saved file | Excel Programming | |||
| How set file open path to filepath of file opened with Explorer ? | Excel Programming | |||
Linear Mode
