Document Not Saved

[Jean-Etienne Durand]

Hi,

I have created an excel document under windows xp/office 2003, this
document contains ~20 worksheets, and some vba code behind.
Using this excel file on windows works fine.
On a macintosh, I cannot save the document ("Document not saved")
I try with Panther/Tiger and Office X,Office 2004 without and with
updates. Note, that the file is stored locally, and is unprotected.

By deleting some vba modules, i can save again, but there is no way to
reproduce this systematically (deleting a given vba module could solve
the problem for one save, but only once)

Browsing the web, i see that I am not the only one having this
behaviour, but I couldn't find any answer.

Any clue ?
I can provide the XLS file for those who want to help me.

BR,
Etienne
<[email protected]>

 

[Jim Gordon MVP]

Hi Jean-Etienne,

If you can put the file somewhere on the web for download there are
several of us who are willing to give it a try. Just reply with the URL.

Thanks.\

-Jim

 

[Jean-Etienne Durand]

Where could I put it ?

 

[Jonathan Tanner]

I have placed the file on my personal site solely for the purposes of easier
sharing. The link is http://www.aztanners.com/renovgrid there should be a
folder and a separate .xls file.

I hope this helps

 

[Jonathan Tanner]

Sorry its actually http://www.aztanners.com/renovgrid


I forgot to rename it.

 

[JE McGimpsey]

Sorry its actually http://www.aztanners.com/renovgrid

Your Userform, and perhaps one or more of your modules were corrupt. I
replaced them with new modules (copying the text to new modules) and a
new userform (again copying the code). As a precaution I copied all but
the first and last character from each module, then added them back in
the new ones, but I suspect that may be superstition.

Code modules notoriously become corrupt with frequent editing.

If you have access to WindowsXL, run Rob Bovey's Code Cleaner:

http://www.appspro.com/Utilities/CodeCleaner.htm