Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
Renaming VB Form Causes Macro Corruption | Excel Programming | |||
User cannot print form object after worksheet sent not as attachment | Excel Programming | |||
Multipage Object on User Form | Excel Programming |