I have two workbooks in a folder. The first open automatically and does what it should do then it calls the second workbook to open. The code appears to require a complete path in order to find the second workbook. If it were only to run on my computer, it would be fine as it is. However once I get it working, it will be placed on a SharePoint server to be downloaded and used by anyone who needs it. When that happens, the first workbook can no longer locate the second, as it is looking for my C:/ drive. I tried truncating the addy to C:/(name of folder both files are in)/(name of second workbook). That still results in an error. Any way to make this a relative address instead of absolute? (NOTE: I am a self-taught VBA newbie. Be gentle.)
