Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to: User Form to assign a user defined range to a macro variab TrevTrav Excel Programming 1 March 22nd 05 07:57 PM
Renaming VB Form Causes Macro Corruption James[_25_] Excel Programming 1 July 14th 04 03:01 PM
User cannot print form object after worksheet sent not as attachment Kevin Mitchell Excel Programming 1 April 20th 04 05:01 AM
Multipage Object on User Form Paul Cheers Excel Programming 2 November 27th 03 11:40 AM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"