Mar 15 2005, 01:18 PM
In my database, i have several excel files linked as tables into the database. When the database is moved from one computer to another, the links are broken because the same drive or directory may not be available.
Is it possible to dynamically change the pathname to the linked tables/files in VBA?
Mar 15 2005, 01:56 PM
Is not possible to change the path to a linked file/table . You will have to delete the old link and re-create the links.
Note - if the files are located on a server, then use the UNC path rather then Drive mapping letter (the drive could be mapped by using different letters )
Mar 15 2005, 02:02 PM
Thanks, I was afraid of that. It also explains why I couldn't find any reference anywhere to doing it.
Instead of a static link, I may just hard code the importing of the data, that way I can control the source path.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here