Problem with Excel File Opening

Posted by JohnH on July 16, 2001 9:23 AM

When I open an Excel file I get the following error message everytime:

'MS&Access Form...,,,' could not be found. Check 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 that the file
has not been renamed, moved, or deleted. OK.

Then the file proceeds to Open once flash and open again. Because of this double open sequence my VB code hangs up.

Any idea of what is going on?

Thanks.

John

Posted by Ivan F Moala on July 17, 2001 3:38 AM

Try Disabling the macros.
The look in VBA editor for any code that
accesses MsAcess forms etc....in this case the error msg
may be correct in that the Msacessform is no longer in
the correct Dir or misspelled.........

Ivan

Posted by JohnH on July 17, 2001 5:08 AM

This happens even if I just double click the Excel Icon so it can't be VB code within the workbook. It must be something to do with the Excel installation. I will try and reinstall it to see if it clears up the problem.

Posted by John on July 17, 2001 7:01 AM

Reinstalling Excel didn't fix the problem but Regedt32 did find an OPEN1 statement with the offending error message in the Excel Keys section. Deleting that statement seems to have solved the problem. Now my Excel opens as it should and my Access program's problem has also be resolved as a result of this action.