Autosave corrupts userforms.

[Guest]

I have a problem with user forms getting corrupted. The issue is found when
the user of the workbook tries to save the file after autosave has been
performed. The message says “Error saving fileâ€. If I look at the vba
projects and try to open up ANY form I get an I/O Error. The only way to save
the file is to delete ALL form objects.


Any thoughts as to why I might no be able to save files / getting corrupt
forms?

Thanks in advance,

Stewart Rogers
DataSort Software, L.C.

 

[Jan Karel Pieterse]

Hi Datasort,

I have a problem with user forms getting corrupted. The issue is found when
the user of the workbook tries to save the file after autosave has been
performed. The message says “Error saving fileâ€. If I look at the vba
projects and try to open up ANY form I get an I/O Error. The only way to save
the file is to delete ALL form objects.

This is a bug in Excel 2000, which should be fixed by updating to SR3.

You might benefit from downloading my Autosafe utility:
www.jkp-ads.com/download.htm

Look for Autosafe.zip
After installing switch off the default Autosave.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

More information: It looks like anytime I save a file that the code is
changing because I am getting a message that says the signed project has been
modified. The scenario is as follows.

From a template (xlt): upon open you have to go thru a wizard to rename the
file. Once the rename process is complete then if you save it again the vba
project seems to change b/c of the signed project modified message.

If you do not save it before autosave kicks in then autosave will trash the
vba forms.

I have tried exporting all forms out of the project and then deleting …
followed by importing the forms.