IE Problem Fixer - Way to Fix Windows IE Problems
last updated on: 11/10/16 08:45AM
   How Can You Fix Errors were detected while saving only after I run a vba macro and save [13/07/16 05:35AM]   
You already voted for this post!

"Errors were detected while saving..." only after I run a vba macro and save

This is specific to this workbook I'm working on which has a vba macro on a XP Pro SP3 w/ Excel 2010
The behavior is basically, I open the workbook and run the macro.
 When it finishes, I save the workbook.
 And when I reopen the workbook and try to save again, I get the error.
 And as some of you may know, I can't just continue and try to save because
the resulting workbook is completely garbaged.

If do not run the macro, I do not have this issue.
 Also, I found out that when I open this workbook in Excel 2007, it opens and saves fine.
 Stranger even, when I open the workbook that was saved in 2007, I can open it and save it just fine once again.

This particular issue doesn't seem to be specific to 2010 although it's more reproducible in 2010 in that it happens every time.
 I was also able to reproduce this bug in 2007 but not every time.
 But when it does happens on 2007, I can take the workbook
and open it in 2010 and voila, it opens and saves ok.
 So this "corrupted" workbook can be opened by the other versions.
 It's like a ping-ping match.

I also noticed that when I run the macro, it takes a significant time to "finish" - meaning there is a big delay after the macro finishes and gives the control to the user.
 I am assuming that there is some kind of cleaning up going on.
 This delay wasn't
there from the beginning but it started at some point during the development as my codebase got bigger.

The other thing I noticed is that there are two parts of the macro or two separate macros I run.
 The first one is purely functional, meaning there are no class modules involved, while the second macro uses class modules extensively w/ all its "fake" polymorphism/inheritance
implementations via interface, etc.
 The reason I mention this is that when I run the first macro and save, the corruption does not occur while the second macro does.
 So I have a suspicion that it might be related to that - perhaps objects not getting garbage-collected
correctly.

Anyone have an idea?

Solutions to the Problem "Errors were detected while saving..." only after I run a vba macro and save



Click here to download the registry repair application


Another Safe way to Repair the problem: "Errors were detected while saving..." only after I run a vba macro and save:

Click here to download the registry repair application .

How to Fix "Errors were detected while saving..." only after I run a vba macro and save with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Run it, and it will scan your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Countifs drag down/across help needed [Solved],How to change or delete the search engine homepage [Anwsered],I can not get my comcast toolbar to work with Internet Explorer 8. [Anwsered],Scanner Compatability with Window 7 [Anwsered],How to Resolve - System Image to 1 disk, Multiple computers, Same Computer Names?,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),Troubleshooting:pfstudiox Error,[Solved] Svchost Helper,[Solution] Sm1bg exe,How to Fix Problem - Io Device?,Fast Solution to Problem: I Can Error Code 0x6d9
Read More: How to Fix Problem Host Process for Windows Services has stopped HELP,"pdf updater has stopped working" Tech Support,How to Fix - "Failed to get data for LOCALE" error Using Chaos Intellect and Address Swiper?,Tech Support This operation has been cancel due to restrictions on this computer Please contact your system adminstrator,How to Fix - "Error 1402.Could not open key" when installing Adobe reader or acrobat in server 2008r2?,Number format will not convert to Date,"$1450" rounding down to 1400 b/c it's actually $1449.999250 (but doesn't show the whole number),"Control + right arrow" inserts a tab in Word 2010,"'oldIframe' is null or not an object" when playing internet games,Notification Icons & Clock - both monitors?



   Trackbacks

      TRACKBACK URL: http://ieproblem.blogghy.com/trackback/925791

   Comments

   Post a comment
Name:


Email:


5 + 5 = ?

Please write above the sum of these two integers

Title:


Comments:





About the author

Contact the author
Categories

Latest blog posts
Troubleshooting Error NTFS disc check File system on C corrupted Needs to be checked Error
[11/10/16 08:45AM]
Troubleshooting Difference between Range and Region Error
[27/09/16 05:10AM]
Fast Solution to Error cannot uninstall office from vista
[14/09/16 04:42AM]
How Can You Fix Errors were detected while saving only after I run a vba macro and save
[13/07/16 05:35AM]
Solution to Problem NVIDIA GeForce 8400M GS
[04/07/16 11:05AM]
Top views posts
How to Fix Problem How can I copy the drop down list s fill color
[31/03/16 07:49AM] Daily Views 14
How Can You Fix Errors were detected while saving only after I run a vba macro and save
[13/07/16 05:35AM] Daily Views 13
Solution to Problem NVIDIA GeForce 8400M GS
[04/07/16 11:05AM] Daily Views 12
Fast Solution to Error cannot uninstall office from vista
[14/09/16 04:42AM] Daily Views 10
How to Fix Error Help Need to insert a text value in one cell based on a text match in another cell
[30/03/16 11:23AM] Daily Views 9
Photo Albums








Powered by Blogghy

Page generated in 0.1514 seconds.