Hi Frank,

Thank you for the input. I loaded this add-in, and I'm
working on the problem. You are right. It has to be a
link that is somehow in there.

-----Original Message-----
Hi
maybe there's a link to this file somethere in your
sheet. Try the
following add-in to check for such links:
http://www.bmsltd.ie/DLCount/DLCount...e=FindLink.zip

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im
Newsbeitrag
...
Each January, I save off the entries for the preceding
year and blank out the rows of the spreadsheet. Excel
seems to be looking for the file I saved off for last
year. This seems screwy because my code in no way
addresses this file, and the worksheets themselves make
no
reference to this saved off file of last year's data.

PS -- In Access, you can get to the code of your
application before actually opening the application. As
such, you can debug it line-by-line from the very start.
But I know of no way to do this in Excel. It seems a
Workbook has to be open before you can put a breakpoint
anywhere. Thus, to get a breakpoint on Workbook_open
(), I
put the breakpoint on the line, and then I close the
application. The code will then "hang" at that line
when
the application is reopened. The "file not found" box
pops up before the program "hangs" when re-opened.

-----Original Message-----
Hi Bruce
Workbook_open is the first event you can process.

What file is not found by Excel (what is the exact
error
message)?


--
Regards
Frank Kabel
Frankfurt, Germany


Bruce Maston wrote:
What goes on (if anything) *prior* to the
Workbook_open
event? I'm getting a funny "file not found" box
popping
up when I try to open my application. I set the
debugger
to stop at private sub Workbook_open(), but I only
get
to
that live *after" I cancel out the "file not found"
box.
It's as if whatever is screwing up my code happens
before
the code actually starts!
.


.