I am getting ...

Cannot find the file '<full path name to the .XLS file I click on' (or one
of its components). Make sure the path and filename are correct and that all
required libraries are available

This occurs when I try to open any XLS file in Excel2002.

What is wrong? I made a simple change to the end of one of my macros that
would change the Print area for one of the outputs. And Excel went nuts with
enlarging every cell to 1"x1" and skipped the routine that would re-allow
screen updates. I think what I had done was try to apply formatting to the
Activesheet which in this case was not the correct activesheet. That is
fixed now through excel2000. at the time in excel2002...The only way out was
to TaskList close excel. the "X" out button tried to save something and the
hourglass never went away.

The same file I was working on does open and process all my macros exactly
as they should in excel2000.

I can "OK" through the message and excel is loaded with my commandbars, the
sheet area is grey (no sheet loaded) but then I can then click on any of the
commandbar buttons to run any of my macros and all seems to be just fine. I.E
the data appears, the SQL recordset populates the sheet. All formatting is
done, the upload to mainframe button activates as normal, the shell to FTP
runs perfectly. It appers 100% normal, except for that error message upon
loading (and the need to run one of the macros to un-grey the sheet)

How do i find out what is missing at startup of excel?


--
Regards,
John