G
Guest
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?
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?