On Tue, 29 Jul 2003 01:10:13 -0700, "Rob"
wrote:

I've got a whole load of rubbish (old macros) in my
personal workbook that I've accumulated over the years. A
while ago when opening excel I started getting 'File not
found' messages which I didn't mind just OKing every
time. Now, however, I have 2, one directly after the
other. I realise that these relate to now invalid file
references but I do not know where the error is arising
and which file names it is referring to. Is there a way
of tracking them down?

If it's happening when you start Excel, then it has to be in either
the Workbook_Open event macro (in the workbook's code module), or an
auto_open macro. (Which, incidentally, may or may not be in your
personal.xls workbook; it could be in any workbook in your XLStart
folder, or your alternative startup directory. Although you also have
to consider whether it could be coming from an add-in...)

I'd suggest taking a look at the workbook_open / auto_open macros for
any workbook that loads on startup. Remember that you can also run
those macros manually from the VBE; before doing so, set a breakpoint
so that you can step through the code until you find the offending
line(s).

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *