• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macros in 2007 Running in 2010

F

fkwilliams@gmail.com

New Member
I created a macro in Excel 2007 but when my colleagure tries to open it in Excel 2010, it brings about a message "VBA macro in this workbook have been currupted..."

Anyone know how I can fix this.


Many Thanks in adavnce.
 
Fkwilliams


Firstly, Welcome to the Chandoo.org Forums


There shouldn't be any issues opening a 2007 file in 2010.


A few things you should try on the 2007 machine


1. Open the file using the Open and Repair file option

Goto File Open, select your file and then use the small down arrow next to Open to select Open and Repair


Once open, check the file and make sure it is all ok.


2. Save the file again and save a copy as an Excel Binary File (*.xlsb)


3. Try in 2010 again


4. In 2010, does the file need the same network, internet access or SQL DB access etc as the owner in 2007 has ?, make sure the person has appropriate access if required.


5. Try the Open and Repair in 2010 as well


Please let us know how you go!
 
You must log in or register to reply here.
Back
Top