Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
When I open a workbook (in Excel 2007) that contains a macro, I get the
following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
I'm sure you would have already tried this, but turn off your virus checker,
if you have one running and then try again. "BW" wrote: When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
Uninstall & reinstall Office. Create a new user account and use that. If
that doesn't work rebuild your machine. Its possible that a 3rd party component is interfering so without knowing what is causing the problem a rebuild is usually the quickest and easiest solution. "BW" wrote in message ... When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
"NateBuckley" wrote in message
... I'm sure you would have already tried this, but turn off your virus checker, if you have one running and then try again. I also would suspect the AV software. For example, see http://www.standards.com/Index.html?OfficeStuffExamples. Also, some AV deletes mercilessly, see http://community.mcafee.com/showthread.php?t=186031. -- http://www.standards.com/; See Howard Kaikow's web site. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
I love newsgroups! Thanks so much for all the quick replies! I have just
finished an online chat with McAfee and it doesn't appear that the antivirus software is the problem (same message still appears when all of McAfee is turned off.) Perhaps this may affect the situation - I previously had Office XP on this computer. I recently installed Excel 2007 (not all of Office 2007, but just the Excel piece - mainly because I had to switch the Excel for work but didn't want to have to learn the new version of Word at the same time -so now I actually have Excel 2003 as well as Excel 2007 on this computer.) So it seem that this could maybe cause some sort of problem. But here is my next problem - I just went to try to uninstall the Office XP and I don't seem to be able to - it says "the installation source for this product is not available. Verify that the source exists and you can obtain it." Not sure what this means! I put in my original Office XP CD, thinking that would be what it wants, but I still get this same message. Any ideas about how I can get past this message to be able to uninstall Office XP and then try installing Office 2007 to see if that fixes my original problem? Again, thanks much for any help you can give. "Castell" wrote: Uninstall & reinstall Office. Create a new user account and use that. If that doesn't work rebuild your machine. Its possible that a 3rd party component is interfering so without knowing what is causing the problem a rebuild is usually the quickest and easiest solution. "BW" wrote in message ... When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
"BW" wrote in message
... I love newsgroups! Thanks so much for all the quick replies! I have just finished an online chat with McAfee and it doesn't appear that the antivirus software is the problem (same message still appears when all of McAfee is turned off.) Perhaps this may affect the situation - I previously had Office XP on this computer. I recently installed Excel 2007 (not all of Office 2007, but just the Excel piece - mainly because I had to switch the Excel for work but didn't want to have to learn the new version of Word at the same time -so now I actually have Excel 2003 as well as Excel 2007 on this computer.) So it seem that this could maybe cause some sort of problem. But here is my next problem - I just went to try to uninstall the Office XP and I don't seem to be able to - it says "the installation source for this product is not available. Verify that the source exists and you can obtain it." Not sure what this means! I put in my original Office XP CD, thinking that would be what it wants, but I still get this same message. Any ideas about how I can get past this message to be able to uninstall Office XP and then try installing Office 2007 to see if that fixes my original problem? Again, thanks much for any help you can give. "Castell" wrote: Uninstall & reinstall Office. Create a new user account and use that. If that doesn't work rebuild your machine. Its possible that a 3rd party component is interfering so without knowing what is causing the problem a rebuild is usually the quickest and easiest solution. First, I would not rely on what McAfee tech support says. In the McAfee forums, nobody from McAfee ever owned up to the issue I raised about deleting files. A number of experienced McAfee users confirmed the issue. I would never use McAfee, unless it could be demonstrated that the issue I raised had gone away, and even then, why use McAfee when there are better alternatives such as Kaspersky available? More importantly, OFFICIALLY, tho MSFT mealy mouths this in KB articles, two versions of Office are not FULLY compatible running concurrently. Some folkes do this and face no problems, but that's just asking for trouble, especially when dealing with macros. I've not yet used Office 97, but it would not surprise me if either Excel 2003 or 2007 got unhappy when flip flopping between versions in the same OS. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
If your Office XP installation was an "upgrade" it may be looking for the
discs for the product you upgraded from - usually MS Works. Otherwise, if this doesn't work best solution is going to be a rebuild of your computer. "BW" wrote in message ... I love newsgroups! Thanks so much for all the quick replies! I have just finished an online chat with McAfee and it doesn't appear that the antivirus software is the problem (same message still appears when all of McAfee is turned off.) Perhaps this may affect the situation - I previously had Office XP on this computer. I recently installed Excel 2007 (not all of Office 2007, but just the Excel piece - mainly because I had to switch the Excel for work but didn't want to have to learn the new version of Word at the same time -so now I actually have Excel 2003 as well as Excel 2007 on this computer.) So it seem that this could maybe cause some sort of problem. But here is my next problem - I just went to try to uninstall the Office XP and I don't seem to be able to - it says "the installation source for this product is not available. Verify that the source exists and you can obtain it." Not sure what this means! I put in my original Office XP CD, thinking that would be what it wants, but I still get this same message. Any ideas about how I can get past this message to be able to uninstall Office XP and then try installing Office 2007 to see if that fixes my original problem? Again, thanks much for any help you can give. "Castell" wrote: Uninstall & reinstall Office. Create a new user account and use that. If that doesn't work rebuild your machine. Its possible that a 3rd party component is interfering so without knowing what is causing the problem a rebuild is usually the quickest and easiest solution. "BW" wrote in message ... When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
solution
using the directions here will solve your problem
http://www.excel-vba.com/vba-excel-install.htm B wrote: "Macros are corrupted and have been deleted" message 04-Apr-08 When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. Previous Posts In This Thread: On Friday, April 04, 2008 11:39 AM B wrote: "Macros are corrupted and have been deleted" message When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. On Friday, April 04, 2008 11:50 AM NateBuckle wrote: I'm sure you would have already tried this, but turn off your virus checker, I am sure you would have already tried this, but turn off your virus checker, if you have one running and then try again. "BW" wrote: On Friday, April 04, 2008 11:51 AM Castell wrote: Uninstall & reinstall Office. Create a new user account and use that. Uninstall & reinstall Office. Create a new user account and use that. If that doesn't work rebuild your machine. Its possible that a 3rd party component is interfering so without knowing what is causing the problem a rebuild is usually the quickest and easiest solution. "BW" wrote in message ... On Friday, April 04, 2008 12:20 PM Howard Kaikow wrote: "Macros are corrupted and have been deleted" message "NateBuckley" wrote in message ... checker, I also would suspect the AV software. For example, see http://www.standards.com/Index.html?OfficeStuffExamples. Also, some AV deletes mercilessly, see http://community.mcafee.com/showthread.php?t=186031. -- http://www.standards.com/; See Howard Kaikow's web site. On Friday, April 04, 2008 12:35 PM B wrote: I love newsgroups! Thanks so much for all the quick replies! I love newsgroups! Thanks so much for all the quick replies! I have just finished an online chat with McAfee and it doesn't appear that the antivirus software is the problem (same message still appears when all of McAfee is turned off.) Perhaps this may affect the situation - I previously had Office XP on this computer. I recently installed Excel 2007 (not all of Office 2007, but just the Excel piece - mainly because I had to switch the Excel for work but didn't want to have to learn the new version of Word at the same time -so now I actually have Excel 2003 as well as Excel 2007 on this computer.) So it seem that this could maybe cause some sort of problem. But here is my next problem - I just went to try to uninstall the Office XP and I don't seem to be able to - it says "the installation source for this product is not available. Verify that the source exists and you can obtain it." Not sure what this means! I put in my original Office XP CD, thinking that would be what it wants, but I still get this same message. Any ideas about how I can get past this message to be able to uninstall Office XP and then try installing Office 2007 to see if that fixes my original problem? Again, thanks much for any help you can give. "Castell" wrote: On Friday, April 04, 2008 1:02 PM Howard Kaikow wrote: "Macros are corrupted and have been deleted" message "BW" wrote in message ... antivirus just now next to that about Again, a First, I would not rely on what McAfee tech support says. In the McAfee forums, nobody from McAfee ever owned up to the issue I raised about deleting files. A number of experienced McAfee users confirmed the issue. I would never use McAfee, unless it could be demonstrated that the issue I raised had gone away, and even then, why use McAfee when there are better alternatives such as Kaspersky available? More importantly, OFFICIALLY, tho MSFT mealy mouths this in KB articles, two versions of Office are not FULLY compatible running concurrently. Some folkes do this and face no problems, but that's just asking for trouble, especially when dealing with macros. I've not yet used Office 97, but it would not surprise me if either Excel 2003 or 2007 got unhappy when flip flopping between versions in the same OS. On Saturday, April 05, 2008 8:49 AM Castell wrote: If your Office XP installation was an "upgrade" it may be looking for the If your Office XP installation was an "upgrade" it may be looking for the discs for the product you upgraded from - usually MS Works. Otherwise, if this doesn't work best solution is going to be a rebuild of your computer. "BW" wrote in message ... Submitted via EggHeadCafe - Software Developer Portal of Choice Get Silverlight 4 Installed: Tips and Tricks http://www.eggheadcafe.com/tutorials...4-install.aspx |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Macros are corrupted and have been deleted" message
On Friday, April 4, 2008 5:39:01 PM UTC+2, BW wrote:
When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one. However, I know that there isn't a corruption problem with the workbook because I can take this same workbook and open it on another computer without problem - and with the macros present and running fine. This has happened on every workbook I have tried to open (that contains macros) - lots of them.. So it isn't a problem with a workbook - it is something on my computer. I teach and I need to open and grade students' workbooks - and they contain macros! So I don't know what to do! I would appreciate any suggestions you can give. Any answer below containing, reinstalling, virus and or anything else containing Windows or microsoft can be ignored safely as it DOESNT fix Your problem. First off you may not have lost Your macros in the deletion of them in the original file, they still may exist in PERSONAL.XLSB located at "X:\Users\Account\AppData\Roaming\Microsoft\Excel\ XLSTART\". Anyway the real issue of why its deleteing Your code is simply ((""Visual Basic for application"")) is not installed, so when Excel tries to activate it, it wont run and just gives a corruption Message (god knows why microsoft didnt just program it to say "yoh, Excel lacks VBA" or something like that, and just disables macros... Anyway ill link you to a Picture filled install guide how to do it. http://www.excel-vba.com/vba-excel-install.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Bypass the "Macros may contain viruses . . ." message | Excel Programming | |||
Code to ignore on-screen message concerning "Enable Macros." | Excel Programming | |||
Can I "sign" my own macros? or some other fix for the message about security and macros? | Excel Programming |