XL2K and Links

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top