Debug Error -2147221231

Jonnyu182

Board Regular
Joined
May 30, 2008
Messages
104
Hi all,

When trying to run the following code:
Code:
CreateObject("WScript.Shell").Popup "Unable to Access that information.", "&" _
        & 4, "Mystic Excel Says..", vbInformation


I get the following error:
Automation error
ClassFactory cannot supply requested class
Error ID: -2147221231

I googled it and 1 page mentioned invalid DLL's. I tried copying these off a collegues machine but was not able to replace them as there always running. There size was identical so i imagine there the same..

I used to to able to run the code fine until our Helpdesk messed with my profile in a attempt to get me access to another program.

Anyone encountered this and if so.. How did you cure it?

Regards
Jonny.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
The security bot wouldnt let me access the page.. Good job I know how to turn him off.

Installed fine but wanted to re-boot however im in the middle of trying to get 8 excel documents to have the same column layout so will give it a miss for now.

Thanks for the link.

J.
 
Upvote 0
Can someone please help me with this? I am out of options at this point. I am not able to load my .XLA file anymore. I get the error and then it says out of memory. Other users are able to load it fine so its got to be something changed on my pc. I am not able to compile the code at all. Please any help is greatly appreciated.

Thank you.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top