XL2K and links...

[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.

 

[John Vinson]

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

 

[Mike Mertes]

I'm sorry everyone. Yesterday I accidently posted this message here, in
haste. I'll repost it in in the proper newsgroup.