Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative Path to a Folder
I have a workbook containing a macro which combines the contents of several
workbooks that are in a sub-folder of the folder in which the combiner resides. The macro uses the following code to identify the path to the subfolder containing the workbooks to be combined: Sub Filter_Data() Get_File_Names _ MyPath:="C:\Documents and Settings\mtn1\Desktop\Test Folder\Templates", _ Subfolders:=False, _ ExtStr:="*.xl*" My problem is this: It's going to be on a network, and not all users will have the same drive letter mapped. I have investigated relative paths, but all the examples I've seen are paths to a specific filename in the target folder. How can I tell the macro to look for workbooks in a subfolder of the folder that contains the macro, without using that folder's absolute path? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative Path to a Folder
Try this and change the 1.2.3.4 to your network IP
\\1.2.3.4\Documents and Settings\mtn1\Desktop\Test\Folder\Templates "Heliocracy" wrote: I have a workbook containing a macro which combines the contents of several workbooks that are in a sub-folder of the folder in which the combiner resides. The macro uses the following code to identify the path to the subfolder containing the workbooks to be combined: Sub Filter_Data() Get_File_Names _ MyPath:="C:\Documents and Settings\mtn1\Desktop\Test Folder\Templates", _ Subfolders:=False, _ ExtStr:="*.xl*" My problem is this: It's going to be on a network, and not all users will have the same drive letter mapped. I have investigated relative paths, but all the examples I've seen are paths to a specific filename in the target folder. How can I tell the macro to look for workbooks in a subfolder of the folder that contains the macro, without using that folder's absolute path? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative Path to a Folder
Try:
MyPath:= ThisWorkbook.Path etc... HTH, Bernie MS Excel MVP "Heliocracy" wrote in message ... I have a workbook containing a macro which combines the contents of several workbooks that are in a sub-folder of the folder in which the combiner resides. The macro uses the following code to identify the path to the subfolder containing the workbooks to be combined: Sub Filter_Data() Get_File_Names _ MyPath:="C:\Documents and Settings\mtn1\Desktop\Test Folder\Templates", _ Subfolders:=False, _ ExtStr:="*.xl*" My problem is this: It's going to be on a network, and not all users will have the same drive letter mapped. I have investigated relative paths, but all the examples I've seen are paths to a specific filename in the target folder. How can I tell the macro to look for workbooks in a subfolder of the folder that contains the macro, without using that folder's absolute path? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative Path to a Folder
Yep, I stumbled on this solution about two minutes after asking the question
lol... Thanks to all for your help. Mike "Bernie Deitrick" wrote: Try: MyPath:= ThisWorkbook.Path etc... HTH, Bernie MS Excel MVP "Heliocracy" wrote in message ... I have a workbook containing a macro which combines the contents of several workbooks that are in a sub-folder of the folder in which the combiner resides. The macro uses the following code to identify the path to the subfolder containing the workbooks to be combined: Sub Filter_Data() Get_File_Names _ MyPath:="C:\Documents and Settings\mtn1\Desktop\Test Folder\Templates", _ Subfolders:=False, _ ExtStr:="*.xl*" My problem is this: It's going to be on a network, and not all users will have the same drive letter mapped. I have investigated relative paths, but all the examples I've seen are paths to a specific filename in the target folder. How can I tell the macro to look for workbooks in a subfolder of the folder that contains the macro, without using that folder's absolute path? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting a path to a folder | Excel Discussion (Misc queries) | |||
Using Relative path for XML data file? | Charts and Charting in Excel | |||
Browse button on form for folder path | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Absolute vs Relative path | Excel Discussion (Misc queries) |