Relative File Link in Macro
 

I am trying to build a summary workbook from several other workbooks.
I'd like to sort the data into montlhly folders and have a macro
combine the sheets that I need in the summary file.

I can make it work once but I can't figure out how to make excel use a
relative file path instead of absolute. How do I get excel to look for
the files in the same folder in which the summary file is located?

Thanks
Jason


--
jpwolf00
------------------------------------------------------------------------
jpwolf00's Profile: http://www.excelforum.com/member.php...o&userid=23654
View this thread: http://www.excelforum.com/showthread...hreadid=374136