| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the path of the .xls file
Greetings,
I currently am using one workbook to open another, now the sheet I open is always located in "\HolSheets\holSheet.xls" and the original workbook is in the folder that is the parent of the directory HolSheets. This will always be so, yet not sure where they want me to copy the report once I've completed it, so does anyone know how to get the root of the original workbook, so then I only need to specify the path like this rootPath & "\HolSheets\holSheet.xls" Being playing around with the filesystem object but still learning that part. Thanks in advance! (Hopefully that was clear enough) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get the path of the .xls file
rootPath = Thisworkbook.path rootPath & "\HolSheets\holSheet.xls" "NateBuckley" wrote: Greetings, I currently am using one workbook to open another, now the sheet I open is always located in "\HolSheets\holSheet.xls" and the original workbook is in the folder that is the parent of the directory HolSheets. This will always be so, yet not sure where they want me to copy the report once I've completed it, so does anyone know how to get the root of the original workbook, so then I only need to specify the path like this rootPath & "\HolSheets\holSheet.xls" Being playing around with the filesystem object but still learning that part. Thanks in advance! (Hopefully that was clear enough) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get the path of the .xls file
I've been messing around with the Filesystem object, trying to do it that way.
Once again thank you. "Mike" wrote: rootPath = Thisworkbook.path rootPath & "\HolSheets\holSheet.xls" "NateBuckley" wrote: Greetings, I currently am using one workbook to open another, now the sheet I open is always located in "\HolSheets\holSheet.xls" and the original workbook is in the folder that is the parent of the directory HolSheets. This will always be so, yet not sure where they want me to copy the report once I've completed it, so does anyone know how to get the root of the original workbook, so then I only need to specify the path like this rootPath & "\HolSheets\holSheet.xls" Being playing around with the filesystem object but still learning that part. Thanks in advance! (Hopefully that was clear enough) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
| http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
| Creating Excel file that points to relative path .cub file | Excel Programming | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| How set file open path to filepath of file opened with Explorer ? | Excel Programming | |||
Hybrid Mode
