Link to home
Start Free TrialLog in
Avatar of Davisro
DavisroFlag for United States of America

asked on

Developed application in Excel 2010 VBA not working in Excel 2007

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?
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

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?
Avatar of Davisro

ASKER

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
It could well be that but that update was some time ago.
Avatar of Davisro

ASKER

Yes, but there've been no VBA workbooks to trigger the error
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial