I have an Excel 2003 macro that will not run in Excel 2010. The macro allows me to extract data from our accounting business system into Excel. However, since we have upgraded to Excel 2010 and Windows 7, the macro will not work. I'm told it is because 2010 is 64bit and runs a newer VBA7.
I know almost nothing about VBA programing. Is there something I can do to make Excel 2010 run the old 32 bit macro? Is there a magic combatability switch?