Avatar of Davisro
Davisro
Flag 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?
Microsoft ExcelVisual Basic ClassicVBA

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon
Roy Cox

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?
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
Roy Cox

It could well be that but that update was some time ago.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Davisro

ASKER
Yes, but there've been no VBA workbooks to trigger the error
ASKER CERTIFIED SOLUTION
Roy Cox

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.