SpreadSheet Compare worked well on my machine until I have had to reinstall ENTERPRISE 2007 completely. But now I am unable to install a functional SpreadSheetCompare add-in. I have tried many of the different advices without success.
There are many complaints with the VBA Debugging start and the first picture in the Word Doc (Picture 1 in the attachment) is identical with others found in several posts concerning the very same problem.
The crucial point, IMHO, is obviously that the VBA project is not stored (Picture 11). After checking this entry I am told that I have to save the project to be able to add a reference. However, the *.xlam cannot be saved" (Picture 12). The offered solutions fail too.
On the other hand I can check the OLE automation box but then the error " Unable to execute the Makro CompareClick_Handler" pops up in the Excel window (map1).
Interestingly there is a directory "Office14" in addition to Office12 that shows dll files like GKExcel.dll and GKExcel2.dll which are security updates. Are they involved in the story?
I am sure that there is a simple solution.
Please advise.
My OS: Windows XP Professional SP3
Don't think the VBA project has anything to do with it. These usually appear when an xls workbook has VBA code in it. I have an example of such in the help and it did not affect Spreadsheet Compare.
I suggest you follow the instructions in the online help:
http://www.thefoolonthehill.net/Help/SpreadsheetCompare/InstallationandErrors.html
http://www.thefoolonthehill.net/Help/SpreadsheetCompare/CompileerrorAutomationerror.html
In your case, all looks fine. Excel is a bit of a pain in this regard because it just does not work! Check the paths as detailed in the links above and run the office repair.
Steve
Hallo Steve,
I followed the instructions in the online help without success.
XLAM is installed in the correct folder
The References are checked as proposed in the help example, my object libraries are for Excel 12.0 however.
Therefore MSO.DLL and Excel.exe are in the Office12 folder. I have VBA6 on my machine.
Additional controls are identical i.e. frmMain is present.
However, I cannot open the Toolbox Window because it is greyed out!
Should I manually register the following files?
C:\Windows\System32\FM20.DLL
C:\Windows\System32\MSCOMCTL.OCX
C:\Program Files (x86)\Microsoft Office\Office14\REFEDIT.DLL
Very frustrating after using and enjoying SpreadSheetCompare until the 20th June this year.
Karl
Strange that the toolbox is greyed out. When opening Excel, click the square 'stop' button to stop the IDE. You may then be able to bring up the toolbox.
Did you do a repair of Excel through Add/Remove programs?
You can try this patch. It fixes other issues: http://support.microsoft.com/kb/2748410
These Excel issues are very annoying, I agree.
Steve
Hello Steve,
SpreadSheetCompare now does its job!
I had prepared already new screen shots for your inspection and advice which are shown now in a new Word Doc for a general information. There is of course the drawback of the German language and the "Enterprise 2007" software.
BTW, these shots were obtained before the installation of SpreadSheetCompare
As one can see there is the option of developer tools that open the Tabs below.
Clicking Visual Basic opens the next window .... Tools are greyed!
By chance I clicked the Tab Einfügen (insert) and a menu pops up which shows the elements of the toolbox in the ActiveX part. I looked up the control elements and found all the files listed which appear to be necessary. They appeared all registered.
As you can see there is the option "Registering user defined controls". I thought let's do it.
In a "Try and Decide Mode" I REregistered(?) the three elements all at once:
C:\Windows\System32\FM20.DLL
C:\Windows\System32\MSCOMCTL.OCX
C:\Programme\Microsoft Office\Office12\REFEDIT.DLL
using the simple procedure offered in the menu.
Now I installed SpreadSheetCompare and was surpised and happy - no more problems with your XLAM.
It could be that the crucial file is MSCOMCTL.OCX to be registered. But who knows.
I hope the couple of hours spent by me (and of course your engagement) will be of some value for others. Thanks for your time to help me.
Karl
Great! Don't see how it could have done anything because they were already registered, but maybe one was incorrectly registered before.
I am updating the help to include your instructions for others, and split out the existing info into separate sections. The reason that the toolbox icon is disabled is in the help as well. I was because a form was not open.
Here are the links to the new help. See if I have included the steps.
http://www.thefoolonthehill.net/Help/SpreadsheetCompare/CheckingAddingRequiredControls.html
http://www.thefoolonthehill.net/Help/SpreadsheetCompare/CompileerrorAutomationerror3.html
Thanks, Steve
Hello Steve,
yes you did a good job with the actualized help file.
"The reason that the toolbox icon is disabled is in the help as well. I was because a form was not open."
I could not find the solution for the disabled toolbox icon. In your example screen picture it is outgreyed too (?). A right click does not open the tool box.
However, suddenly I realized this option in the quickstart ribbon in Excel.
May I ask you where one can find a link on your page to this help file "SpreadsheetCompareHelp.html".
I would like to suggest to show up a direct link for this help i.e. on the support page AND the bugs page. "The Best Way ... and a Direct Way??
What about an regular update in the software package?
After solving the problem a more direct way for registering OCX or DLL files is certainly known by the experts. I have found a valuable link for this action:
http://www.wikihow.com/Register-a-DLL
Given the paths are correct the commands should look like:
regsvr32 "C:\Windows\System32\FM20.DLL"
regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"
regsvr32 "C:\Program Files (x86)\Microsoft Office\Office14\REFEDIT.DLL"
A good idea would be to register the files step by step and test Spreadsheet Compare to learn which file is is responsible for the failure.
IMHO it may be helpful to add this registry information directly in: http://www.thefoolonthehill.net/Help/SpreadsheetCompare/SpreadsheetCompareHelp.html?CompileerrorAutomationerror3.html
It would be nice to have a feedback whether the "Registry Story" was helpful indeed.
Karl
The icon looks the same either way. To enable it, you need to open a form and have it selected.
Where? I would like to add it to the help file.
It is accessible from the home page on the Sourceforge summary page.
I don't know if that is possible.
I will do an update for the help file shortly.
Originally I had the installer register everything and it caused more problems. Excel would detect that files had changed and would start the repair wizard when Excel started. As all those components as supposed to be provided by Excel, there should be no need to do anything else. 99% of the time everything works fine. 1% of the time it does not. Sometime it doesn't work on my PC! and I have to run through the same steps as everyone else.
Steve
May I report the following observation for entertainment:
Today eleven new Windows Updates were installed on my machine (XP Pro SP3). The result was the above discussed annoying Spreadsheet Compare failure.
Strange enough I had to look up my own advice in this forum.
I manually re-registered the files stepwise with the commands
regsvr32 "C:\Windows\System32\FM20.DLL"
No effect!
regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"
Spreadsheet Compare works!!
I omitted therefore to re-register
regsvr32 "C:\Program Files (x86)\Microsoft Office\Office14\REFEDIT.DLL"
The update of the Windows tool “removing maleficent software” or what ever it is called in English could be the malefactor.
Karl
I was running into similar symptoms regarding the "Compile error: Automation error" and by re-registering the following, I was able to now successfully use Spreadsheet Compare again.
regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"
Thanks for catching this!