I have created a spreadsheet that has links (i.e., like a menu page) to other spreadsheets via the insert, hyperlink menu choices–I then link to an existing file. All of the Excel spreadsheets are on the same drive (c:) and in the same folder (production). Everything works great. But now, I have been requested to make this application (i.e., the spreadsheets) available via a USB flash drive so that associates can work on these spreadsheets while away from the office. I then copied the spreadsheet files to the USB flash drive—no problem yet.
The problem is that all of the links are “hard” coded, C:JCCproductionfilename.xls. Naturally this directory only exists on my “C” drive on my work computer. Is there a way to make the links to the other spreadsheets dynamic, that is to use whatever letter the USB flash drive may be when the initial worksheet is opened? While the drive letter is dynamic, the “production” folder will always be on the USB drive and contain all of the EXCEL files. Has anyone created a “portable” excel application to be used via a USB drive?
I would love to tell you that my end users are sophisticated enough to go to Windows explore and locate the various spreadsheets—but they are not. To make this application work via a USB drive, it has to work like it does at the office. THANKS.
