excel macro looking for file that doesn't exist

  • Thread starter Thread starter regisphilbin
  • Start date Start date
R

regisphilbin

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
 
BTW:

The message I get from Excel is:

"filename.xls" could not be found. Chcek the spelling of the file name,
and verify that the file location is correct. If you are trying to
open the file from your list of most recently used files on the File
menu, make sure the file has not been renamed, removed or deleted.
 
Back
Top