XL2K and links...

  • Thread starter Thread starter Mike Mertes
  • Start date Start date
M

Mike Mertes

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.
 
Some of our workbooks contain links to other workbooks.

Please ask this question in an Excel newsgroup. This newsgroup is for
VBA coding on Access Database forms; it's unlikely anyone here will be
able to help with your Excel-specific question.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
I'm sorry everyone. Yesterday I accidently posted this message here, in
haste. I'll repost it in in the proper newsgroup.
 
Back
Top