Excel 2003 VBA - Need to open a workbook in a fold
I have two Excel 2003 workbooks in a folder. The first opens automatically and runs until it is done and then it calls the second workbook to open. Apparently this requires that I hardcode the full path for the second file (at least, that is what I've had to do to get it to work). As long as the files run on my computer, this works fine. My problem is that when I've finally finished with these files, they are to be stored zipped into a folder on a SharePoint server to be downloaded by anyone who needs them to be run on their computers.
This is where my grand strategy falls to pieces. The zipped folder is downloaded to a different computer and extracted. Once the first file is opened, everything works until the second workbook is called. The second workbook cannot be found and an error stops the whole shebang. I've tried truncating the address to C:\(the folder both files live in)\(name of second workbook file). That doesn't work either.
Is there a way to make this work using relative addresses intead of absolute addresses?
Any help would be greatly appreciated.