Thread: XL2K and Links
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mertes Mike Mertes is offline
external usenet poster
 
Posts: 44
Default 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