Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
BW BW is offline
external usenet poster
 
Posts: 49
Default "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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 146
Default "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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default "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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default "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   Report Post  
Posted to microsoft.public.excel.programming
BW BW is offline
external usenet poster
 
Posts: 49
Default "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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default "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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default "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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default "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
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
"excel "macros may be disabled" message using an xlam file frustrated Excel Worksheet Functions 2 July 13th 09 08:32 PM
Deleted the pivot table - continue to get the "overlap" error message [email protected] Excel Discussion (Misc queries) 0 September 27th 06 04:07 PM
Bypass the "Macros may contain viruses . . ." message Al Excel Programming 5 October 21st 05 07:38 PM
Code to ignore on-screen message concerning "Enable Macros." Phil Hageman[_3_] Excel Programming 2 February 26th 04 02:51 PM
Can I "sign" my own macros? or some other fix for the message about security and macros? BruceJ[_2_] Excel Programming 8 November 6th 03 01:46 AM


All times are GMT +1. The time now is 09:22 AM.

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"