Can't Reference 64 bit Shell32.dll in 64 bit Excel VBA

  • Thread starter Thread starter AV695
  • Start date Start date
A

AV695

Guest
I built a 64-bit COM DLL and have referenced it in Excel's VBA references dialog. It used to run fine but recently started giving the error:"Run-time error '430' Class does not support Automation or does not support expected interface"I think the problem is that the "Microsoft Shell Controls And Automation" library points to C:\Windows\SysWOW64\Shell32.dll" - which is the 32-bit version of that DLL on 64-bit Windows.I've tried everything I can find to unregister that and register C:\Windows\System32\Shell.dll (the 64-bit version on 64-bit Windows), but Excel will not change.Does anyone know wh

Continue reading...
 
Back
Top