AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,052
- Office Version
- 2019
- 2010
- Platform
- Windows
I have an xlsm file created in Office 2010 and have copied it to a 2nd machine running Office 2007
On attempting to run a macro it reported a Missing reference "Mircosoft Windows Common Controls 6.0 (SP6) and that it wants MSCOMCTL.OCX in C:\Windows\Sytem32.
I have copied it there but it still shows MISSING in Tools - References.
Shouldn't the "MISSING" part go away ?
If I ignore that and run code (which opens an ADODB Connection) it shows "Can't Find Project Or Library" on adOpenStatic in the line
If I try Debug-Compile it again reports "Can't Find Project Or Library" this time on line
I'm a bit lost sorting this. Can anyone help ? All works fine in Office 2010
On attempting to run a macro it reported a Missing reference "Mircosoft Windows Common Controls 6.0 (SP6) and that it wants MSCOMCTL.OCX in C:\Windows\Sytem32.
I have copied it there but it still shows MISSING in Tools - References.
Shouldn't the "MISSING" part go away ?
If I ignore that and run code (which opens an ADODB Connection) it shows "Can't Find Project Or Library" on adOpenStatic in the line
VBA Code:
rx.Open sql, cnn, sql, adOpenStatic, adLockReadOnly
VBA Code:
Private Sub ListView1_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
I'm a bit lost sorting this. Can anyone help ? All works fine in Office 2010