#37 Error first run v1.26.0 on Excel 2010: Could not load some objects

[Anonymous]

Hello to the team. I installed Spreadsheet Compare v1.26.0 on my system with Excel 2010 SP-3 (I think) v14.0.6129.5000 (64-bit).

When I launch Excel by itself or try to run the add-in for the comparison, I get the error dialog:

"Could not load some objects because they are not available on this machine." which prompts to the debugger window.

Then, I get another error: "Compiler: Variable not defined" that highlights in yellow:

'Resize form to fit the modified tab control
prgCurrentWorksheetProgress.Top

I checked all References that you require, they are there (i.e. Visual Basic for applications, Excel 14.0 Object Library, Forms 2.0 Object Library, Office 14.0 Object Library).

Even tried to re-register (with Admin rights) via command line the c:\windows\sysWOW64\mscomct2.ocx needed file.

I cannot understand if I am missing some kind of library in my Windows (system) folders.

Any help would be appreciated.

[Konstantinos]

I apologize for not logging in first and then submitting my bug here. I am the creator of this ticket. Thank you for your excellent tool and for your time.

[SteveT]

Do you have a checked reference for "Microsoft Windows Common Controls 6.0 (SP6)"? (that's where the progressbar lives). If not, add it (C:\Windows\System32\MSCOMCTL.OCX).

Took the above from the new help file. You listed 'mscomct2.ocx' which is a different file, so can you check/register mscomctl.ocx instead.

Thanks, Steve

[Konstantinos]

Thank you for your reply SteveT.
Yes, it is checked and registered. I re-register it again via CMD with admin rights.
Still getting the same error.
I had removed 2.50.1 and installed 2.60 with the hope that I will not have the error, before posting here, but nothing has changed. Still getting it...

[Konstantinos]

I uninstalled v2.50.1 and re-installed v2.60. I manually then added (again, to be sure) both controls, MSCOMCTL.OCX in SysWow64 and MSCOMCT2.OCX.

I still get the error in Private Sub UserForm_Initialize():

'Resize form to fit the modified tab control
prgCurrentWorksheetProgress.Top = MultiPage1.Height + 5

I cannot really think of doing anything else. Please let me know if you want me to test something further. Many thanks.

[SteveT]

I have added some more things to check in the help file to do with controls. Can you check these:

http://www.thefoolonthehill.net/Help/SpreadsheetCompare/SpreadsheetCompareHelp.html

[Konstantinos]

Hello and many thanks for updating the help file.

In page:
http://www.thefoolonthehill.net/Help/SpreadsheetCompare/InstallationandErrors.html

1. I noticed that in the References window, you've removed the tick from Microsoft Common Controls (v1 or v2) completely. Was this done on purpose? It was there before, I am sure.

2. I opened the form, toolbox and then the Additional Controls. Indeed I was missing the two crucial controls, RefEdit.Ctl and Microsoft Progress Bar.

But I registered, unregistered both MSCOMCTL.OCX and MSCOMCT2.OCX, copied from C:\Windows\SysWOW64\ to C:\Windows\System32\ registered again. Nothing at all. I cannot find this darn Microsoft Progress Bar anywhere...

Please advise. I think we're getting closer!
Just an idea: Can your installer check for the availability and proper Registry entries for all required controls/DLLs/OCXs?

Can this be an issue?
http://support.microsoft.com/kb/2748410

[SteveT]

I don't think the reference is required because we are using a control from the library. Sounds like you have done everything right. The link you sent does contain the same version that I include in the install folder, but it may be worth running the 'fix it' tool in the resolution section as it appears to clean up some registry entries as well.

If that does not work, you could:
1) Try to manually add a progress bar to the form. Maybe the control was removed when it was found to not be registered and is no longer there (needs to be added now it is available on the PC).
2) Comment out the progressbar lines. It is not critical and there are probably only a couple of lines that refer to the prog bar.

A previous version did attempt to install the correct version, but resulted in Excel running a repair after each installation. Maybe there could be a separate register tool that could be run if Excel does not have what it needs.

Steve

[Anonymous]

Hello Steve, thanks for your reply. I tried the "fix it" tool but resulted to nothing.

I cannot find a progress bar to add, in the tool box. Moreover, I cannot find any reference to "Microsoft ProgressBar" control at all, in my system!

The progress bar belongs to the Common Controls, right? Well, despite them being checked (referred to as Microsoft Windows Common Controls 6.0 (SP6)") the progress bar simply doesn't exist!

Could it be that my Excel has any security feature enabled? Or something else? I am trying to think really out of the box, here. But I promise you:

C:\Windows\sysWOW64\mscomctl.ocx
and
C:\Windows\sysWOW64\mscomct2.ocx

are present and one is registered! This is crazy. Even when I manually select to open this control, then in the toolbox I try to add "Microsoft ProgressBar" but I cannot find it. I guess I can't find any MSCOMCTL.OCX objects, as per this link:

http://social.technet.microsoft.com/Forums/en-US/excel/thread/5b241f09-6c76-4320-b302-4cb8224eab7f

I would really appreciate your input and ideas on this. I am sorry to take up your valuable time. Thank you.

[SteveT]

Did you try the 'Checking/Correcting Additional Controls' section of http://www.thefoolonthehill.net/Help/SpreadsheetCompare/InstallationandErrors.html ? This shows how to find the control. Just don't check the check box.

[Konstantinos]

Hello Steve, yes I did. Prior to writing my comment above. It simply doesn't "exist" on my system. In the Additional Controls, it doesn't appear at all. Nothing actually appears from the "Microsoft Windows Common Controls" except Forms!

Despite that, I have tried multiple times to register and re-register:

C:\Windows\sysWOW64\mscomctl.ocx
and
C:\Windows\sysWOW64\mscomct2.ocx

...so I really do not know what else to do. The file exists in Windows folders; I register it via CMD in Administration privileges; I run Excel and open your forms; it's not even on the list, let alone check/uncheck it...

Any (wild) ideas? I am really sorry to present this idiotic issue. Thank you.

[Anonymous]

Not an idiotic issue. It seems that some small percentage of users have issues with controls/dlls of various types. I have looked elsewhere on the web and basically came up with nothing.

It's not ideal, but the only thing I can recommend at the moment is to comment out those lines that give a problem. The progress bar is only for information, so removing it will not cause a problem.

Steve

[Anonymous]

I have the same problem. I have Windows 7 64 bit, Microsoft Office 2013 64 bit. Please help.

[SteveT]

Additionally, you can try registering the control again following the new procedure here. Scroll down to 'Adding Missing Controls':

http://www.thefoolonthehill.net/Help/SpreadsheetCompare/SpreadsheetCompareHelp.html?Introduction.html

Also, have you tried the following. Microsoft issued a patch for the file you are having problems with:

http://www.thefoolonthehill.net/Help/SpreadsheetCompare/SpreadsheetCompareHelp.html?Introduction.html

[John Light]

I read somewhere (i think a reliable source) that said the VB6 common controls were old and did not support 64bit microsoft office.

I commented out all of the prg* lines and will work without the progress bar.

[SteveT]

That's interesting. Can you confirm that you have 64 bit Office, not just 64 bit Windows? Probably 98% of users with 64 bit Windows are running the typical 32 bit Office.

[John Light]

Yes I have 64bit Office.

This is were I got my info: http://social.technet.microsoft.com/Forums/en-US/f3a71d69-580b-4cdb-ae0b-d8189e6cfd40/offce-2010-x64-edition-ships-with-x86-mscomctlocx

However that thread was for office 2010 beta and of course i am running final released version.

Found this:Native 64-bit processes in Office 2010 cannot load 32-bit binaries. This includes the common controls of MSComCtl (TabStrip, Toolbar, StatusBar, ProgressBar, TreeView, ListViews, ImageList, Slider, ImageComboBox) and the controls of MSComCt2 (Animation, UpDown, MonthView, DateTimePicker, FlatScrollBar).These controls were installed by previous versions of Microsoft Office and are installed by 32-bit Office 2010. An alternative must be found for existing Microsoft Office VBA solutions that utilize these controls when the code is migrated to 64-bit Office 2010. 64-bit Office 2010 does not provide 64-bit versions of the Common Controls.

Here http://msdn.microsoft.com/en-us/library/ee691831(office.14).aspx

[Kris]

Hi Steve,

Any chance you would be able to give some direction on which particular lines could be commented out? I also have a 64-bit Office. I've tried a few versions of the above suggestion referring to the progress bar objects, but with no luck.

Thanks!

[SteveT]

When you run the program and it breaks, click the stop (square button). If the line it stops at contains 'ProgressBar', then comment out the line with a ' at the start. Switch back to the Workbook and repeat.

Let me know if you need any more assistance.

Steve

[Kris]

Fantastic! The "Could not load some objects" warning still comes up but it runs fine otherwise. Thanks so much for your help and this great program.