User form Object corruption

[Guest]

I have a problem with user forms getting corrupted. The issues is found when
the user of the workbook tries to save the item. 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.

Recent changes to development environment:

New Laptop: Windows XP Pro SP2
Office XP Pro SP3
Add SQL Server 2005
Add Visual Studio 2005

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

Thanks in advance,

 

[RB Smissaert]

Run this:
http://www.appspro.com/Utilities/CodeCleaner.htm
Good chance it will fix it.

RBS

 

[Guest]

Thanks for the Tip.

I downloaded the file and preformed the clean process. I will keep you
posted.


--
Stewart Rogers
DataSort Software, L.C.

Run this:
http://www.appspro.com/Utilities/CodeCleaner.htm
Good chance it will fix it.

RBS

 

[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.

--
Stewart Rogers
DataSort Software, L.C.

Run this:
http://www.appspro.com/Utilities/CodeCleaner.htm
Good chance it will fix it.

RBS