Developed application in Excel 2010 VBA not working in Excel 2007

Davisro
Davisro used Ask the Experts™
on
I developed a VBA driven workbook in Excel 2010 with ActiveX objects.

I have a user with Excel 2007 and the ActiveX Objects are frozen, combo box and command button. She did something that opened the debugger. I added a reference in the VBA editor for Microsoft Active X objects 2.8

But when I tried to test it I got a compile error.

Is Excel 2007 not compatible or is this a security setting issue?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Roy CoxGroup Finance Manager

Commented:
ActiveX controls can be problematic but they should be backwards compatible from 2010 to 2007.

What's the compile error and maybe attach an example workbook?
DavisroBudget Analyst

Author

Commented:
I'm reading that deleting this file will fix it
C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd

from http://stackoverflow.com/questions/27414170/excel-2010-activex-controls-no-longer-working-after-windows-updates

But the IT Dept. is recommending she upgrade to Office 2010. So I'd rather let them handle it
Roy CoxGroup Finance Manager

Commented:
It could well be that but that update was some time ago.
DavisroBudget Analyst

Author

Commented:
Yes, but there've been no VBA workbooks to trigger the error
Group Finance Manager
Commented:
It probably is that, just follow the instructions on the problem computer. Youu could also see if there have been any later updates to put the problem right

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial