A co-worker has created a macro and a toolbar link to run that macro but
it seems to be wanting to link to an no-longer-existing excel file.
I've checked out the VB code, no fixed references to this file. I
know that in in the Macros Dialog Box, there is a "Macros In:"
pulldown menu and once its changed to "This Workbook", the macro runs
fine.

checking out some VB functions, I used the call:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

and via this method, it tries to update the links and when it can't
find this No-longer-existing Excel file, it pops up the dialog box.

So my question is:

Where is it storing this file info?
How can I access it and change the file reference to something else?

Thanks,

Regis



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/