JOHolloway
New Member
- Joined
- May 20, 2004
- Messages
- 9
I have an (inherited) Excel application that was originally written in Win98 a few months ago. When I try to open it on WinXP, it declares that it has to repair the file, wiping out all the VBA code. I've found a work-around using the following steps:
I have the same issue if I try to open this file via Metaframe.
I have no idea what the problem is, and I am hoping one of the board members can help.
- open the file
say "no" to sending report
say "no" to sending report (comes up twice)
go to code area
in immediate window, enter application.enableevents=FALSE
close file but not Excel itself
re-open the file using the Excel menu
go to code area
make any change, even if it's just to backspace over a letter and then retype that letter
save the file
close the file
close the Excel application
I have the same issue if I try to open this file via Metaframe.
I have no idea what the problem is, and I am hoping one of the board members can help.