Having a problem, "Could not load an object because it is not available on this machine"

Question

Hello,

Before you blast me for a repeat topic let me explain.

Until yesterday I was running MS Office Professional 2003 and Windows 7.  Yesterday I install MS Office professional 2010.  Many of the userforms in my applications within Excel use the Treeview and Listview controls.

• I checked the list of "Additional Controls", they were not present
• I researched, found that they were in mscomctl.ocx in C:\Windows\Syswow64\
• The appropriate file is present
• I followed instructions and using the console typed "Regsvr32 C:\Windows\Syswow64\mscomctl.ocx"
• I get the message, "DllRegisterServer in C:Windows\Syswow64\mscomctl.ocx succeeded
• I reload Excel, click through the errors, go to "Additional Controls", they are still not listed
• I close Excel and I try "Regsvr32 /u C:\Windows\Syswow64\mscomctl.ocx" which succeeds
• Then I repeat "Regsvr32 C:\Windows\Syswow64\mscomctl.ocx" which succeeds
• The controls are still no present for selection
• I even tried copying the mscomctl.ocx to the System32 folder and mapping it there, no luck

I've seen a number of discussions linking this issue to a security patch that MS put out in 2012.  I've tried to find and download a newer version of the mscomctl.ocx file (mine is File version 6.1.98.34, Product version 6.01.9834, dated 5/2/2012), but all the links I've found on MS pages are broken.

Any help would be greatly appreciated.  This isn't the first time I've run into this issue, just the first time I've HAD to fix it.

Thanks,

Ken

Answer 1

Thanks for responding :).

I think I'm going to have to bite the bullet and learn VB.NET and create an actual database application.

Answer 2

Unless you need 64 bit addressing for very large worksheets, you would be better installing the 32 bit version of Office, which is Microsoft's recommendation for most users. If that's not possible, you are going to have to search for workarounds. I'm afraid I don't know one.

Answer 3

Any idea what WILL work for 64 bit Office 2010?

Answer 4

You will have to register as administrator - even if you are the administrator - see http://www.gmayor.com/Zips/mscomct2.zip for full instructions.

Note that this is not going to work with the 64 bit version of Office 2010.