Unable to open an excel file on Tiger/Excel2004

[Jean-Etienne Durand]

Hi,

Using Excel2003 on WindowsXP, i have developed some VBA code on an
Excel file. This Excel is quite simple, it contains several sheets, drop
down list, buttons,...
It's possible to open it on Tiger/Excel2004, but after a while (several
open/save/close), it's not possible to open it again on mac
It's still possible to open it on windows.
I already post this problem, an answer was given, saying that I should
use CodeCleaner. This solves the problem, since it's again possible to
open it, after using the CodeCleaner tool.
Anyhow, I always need to do this step on Windows, which is not
convenient at all.

Does anybody know why the file gets corrupted after a while?
CodeCleaner is great, but it exists only on Windows, and the file needs
to be open to run it. Is there any other workaround?

I can provide the file if necessary.

Thank you for your help!
Jean-Etienne

 

[JE McGimpsey]

I can provide the file if necessary.

You're welcome to send me the file, though I'm not sure I'll be able to
tell you any more about why it corrupts (send it from your address
above, with the file zipped or stuffed, to get through my spam filters)

Both WinXL and MacXL have a problem with corrupting code modules (hence
the need for CodeCleaner, or, on the Mac, manual cleaning), though my
experience is that it's the editing, not just opening the file/running
the code that causes the corruption.

Are you running any code that modifies the VB Project in your app?

 

[Jean-Etienne Durand]

You're welcome to send me the file, though I'm not sure I'll be able to
tell you any more about why it corrupts (send it from your address
above, with the file zipped or stuffed, to get through my spam filters)

Both WinXL and MacXL have a problem with corrupting code modules (hence
the need for CodeCleaner, or, on the Mac, manual cleaning), though my
experience is that it's the editing, not just opening the file/running
the code that causes the corruption.

Are you running any code that modifies the VB Project in your app?

The VB project is not modified by the application.
How to correct a corrupted module if I just have MacXL ?

(I have sent you the file to your email)

BR,
JED

 

[Jean-Etienne Durand]

Hi,

Did you receive my mail ?

Etienne

The VB project is not modified by the application.
How to correct a corrupted module if I just have MacXL ?

(I have sent you the file to your email)

BR,
JED

 

[JE McGimpsey]

Did you receive my mail ?

Not that I can find. Try again - I get roughly 1,000 spams a day and
sometimes I miss a good one.