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
slobber72Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
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/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
It works normally for me.
als315Commented:
@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.
Get a highly available system for cyber protection

The Acronis SDI Appliance is a new plug-n-play solution with pre-configured Acronis Software-Defined Infrastructure software that gives service providers and enterprises ready access to a fault-tolerant system, which combines universal storage and high-performance virtualization.

Learn More
Martin LissOlder than dirtCommented:
I have the old version.
slobber72Author Commented:
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
als315Commented:
Here is it (rename from txt to ocx). regsvr32 should be started with admin rights if you have vista or windows 7.
Mscomctl.zip
slobber72Author Commented:
Thankyou very much for your prompt help. This has solved my problem.
Thanks also for posting the mscomctl.ocx file.

Greatly appreciated !!

Regards,
Craig
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.