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: 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 At this point, I am able to open the Excel file on my PC. 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Problem opening Excel app in Win98 and in Citrix

Thread starter JOHolloway
Start date Jan 20, 2005

JOHolloway

New Member

Jan 20, 2005

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:

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

At this point, I am able to open the Excel file on my PC.

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.