Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Excel 2010 VBA - Automation Error - Unspecified Error
Hello,
I have a spreadsheet with some code in it, but when i try to launch one of the forms I get the error:
Compile Error:
Automation Error
Unspecified Error
The error doesn't go to any specific piece of code to give me any hints as to what the actual problem might be.
Then - I view one of the forms I have built in. When i right click on the form and select "View Code" I get the error;
Automation Error
Unspecified Error
I click OK and it is immediately followed by another dialog box with the error:
Property is write only.
I really don't know where to start... I have attached the file I am having trouble with.
I use the button on the second sheet to open the forms called "Treeview".
Thanks in advance for your help.
Craig
120514-JDE-ProcessMap-Documentat.xlsm
I have a spreadsheet with some code in it, but when i try to launch one of the forms I get the error:
Compile Error:
Automation Error
Unspecified Error
The error doesn't go to any specific piece of code to give me any hints as to what the actual problem might be.
Then - I view one of the forms I have built in. When i right click on the form and select "View Code" I get the error;
Automation Error
Unspecified Error
I click OK and it is immediately followed by another dialog box with the error:
Property is write only.
I really don't know where to start... I have attached the file I am having trouble with.
I use the button on the second sheet to open the forms called "Treeview".
Thanks in advance for your help.
Craig
120514-JDE-ProcessMap-Documentat.xlsm
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I think you have problem with MS security update: http://support.microsoft.com/kb/2664258/en-us
You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations:
http://dutchgemini.wordpress.com/2012/04/17/excel-vba-error-could-not-load-an-object-because-it-is-not-available-on-this-machine/
You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations:
http://dutchgemini.wordpress.com/2012/04/17/excel-vba-error-could-not-load-an-object-because-it-is-not-available-on-this-machine/
@MartinLiss: for me also, but only when I've restored old mscomctl.ocx (6.01.9833) and reregistered it. With new (6.01.9834) I have same error. Look at your version, please.
Hi Guys.
I thinkwe are on thr right track here - but I can't find where to download mscomctl.ocx version 6.01.9833. I do have version 6.01.9834 installed.
I have also followed the instructions to delete the .exd files from my SysWow64 directory, but now I just can't find anything newer than version 6.01.9783 on the net.
Update: Btw - I tried using an earlier version of MSCOMCTL.OCX and registered it using regsvr32 - now I get a BIG error: as per attached jpg.
Any help appreciated.
Cheers,
Craig
22-08-2012-11-36-37-AM.jpg
I thinkwe are on thr right track here - but I can't find where to download mscomctl.ocx version 6.01.9833. I do have version 6.01.9834 installed.
I have also followed the instructions to delete the .exd files from my SysWow64 directory, but now I just can't find anything newer than version 6.01.9783 on the net.
Update: Btw - I tried using an earlier version of MSCOMCTL.OCX and registered it using regsvr32 - now I get a BIG error: as per attached jpg.
Any help appreciated.
Cheers,
Craig
22-08-2012-11-36-37-AM.jpg
Here is it (rename from txt to ocx). regsvr32 should be started with admin rights if you have vista or windows 7.
Mscomctl.zip
Mscomctl.zip
Premium Content
You need an Expert Office subscription to comment.Start Free Trial