Thread: [Solved] Incompatibility Excel VBA 2007/2010
View Single Post
 
Old 10-13-2012, 01:46 PM
Paul Cain Paul Cain is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Oct 2012
Location: Australia
Posts: 6
Paul Cain is on a distinguished road
Default
Hi Colin

I have attached an xlsm file with 1 module. It was created in Excel 2007 64 bit by importing the attached bas module. This file will open in Excel 2007 but the module will not load into Excel 2010 64 bit.

With 2010 open open, the bas file can be imported.

This should demonstrate the problem well, but you will not want to try and understand the code as it has been obfuscated. For this particular module, only Option Explicit is loaded in 2010.

thanks
Attached Files
File Type: zip 1 Module created in 2007.zip (60.0 KB, 14 views)
Reply With Quote