ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User form Object corruption (https://www.excelbanter.com/excel-programming/350583-user-form-object-corruption.html)

Datasort

User form Object corruption
 
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,

--
Stewart Rogers
DataSort Software, L.C.

RB Smissaert

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

RBS

"Datasort" wrote in message
...
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,

--
Stewart Rogers
DataSort Software, L.C.



Datasort

User form Object corruption
 
Thanks for the Tip.

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


--
Stewart Rogers
DataSort Software, L.C.


"RB Smissaert" wrote:

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

RBS

"Datasort" wrote in message
...
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,

--
Stewart Rogers
DataSort Software, L.C.




Datasort

User form Object corruption
 
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.


"RB Smissaert" wrote:

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

RBS

"Datasort" wrote in message
...
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,

--
Stewart Rogers
DataSort Software, L.C.





All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com