excel macro looking for file that doesn't exist
 

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/

excel macro looking for file that doesn't exist
 

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.



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

excel macro looking for file that doesn't exist
 

Edit|Links would allow you to change the source(s).

I like this utility from Bill Manville.

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

regisphilbin wrote:

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/

--

Dave Peterson