ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XL2K and Links (https://www.excelbanter.com/excel-programming/317217-xl2k-links.html)

Mike Mertes

XL2K and Links
 
Some of our workbooks contain links to other workbooks. I've found that when
I move a workbook with links, the paths of the link sources change to the
directory I moved the file to. Let me tell you, this is a real pain in the
butt when you move 4,654 workbooks to new directories like I did yesterday.

I have to assume that the links are relative, not absolute. Is there a way
to change this?

I'm not very familiar with links, (I prefer to do everything
programatically,) so any information you can offer would be very
appreciated.

Thanks again.


--
-Mike Mertes
Airtron, Tampa Bay




All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com