| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove end folder from path found with ThisWorkbook.Path command ?
LOL! <g
"Dave Peterson" wrote in message ... I happened to answer Dim(!)'s followup post right before I saw this one. The subject is: Find WkBk Path, Then use this path to open another WkBk in Sub === But your response was much more VBAish. <bg Zack Barresse wrote: Hi Dave, Where do you find these threads? I certainly would have thought twice for double- or cross-posting(s)... -- Zack Barresse "Dave Peterson" wrote in message ... Check your previous thread. dim wrote: Hi, I have a problem using the code below: Workbooks.Open ThisWorkbook.Path & "\Data\Book2.xls" Im trying to use the above command within Book2.xls. The file and path is: C:\Program Files\MyProgram\Data\Book2.xls But I want to open the following: C:\Program Files\MyProgram\Data1\Book3.xls When I use: Workbooks.Open ThisWorkbook.Path & "\Data1\Book3.xls" Im told that the path C:\Program Files\MyProgram\Data\Data1\Book3.xls could not be found. How can I determine the path, then remove the last folder section from it before adding in the new folder and file to open?....Is this possible? I Need Help! :drowning: :( -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ThisWorkbook.Path & Windows Vista | Excel Programming | |||
| ThisWorkbook.Path not working... | Excel Programming | |||
| ThisWorkbook.Path not updating | Excel Programming | |||
| ThisWorkbook.Path | Excel Programming | |||
| Custom Footer using ThisWorkbook.Path? | Excel Programming | |||
Threaded Mode
