Hello everyone!
This is my first post here! I guess I am what people call an Office 2003 power user, but I cannot code to save my life! (Have two degrees in Management Info Systems, but I rely on people like you to help me!)
I must have searched the web for three hours looking for an answer. No dice.
So, here's the situation.
I have a cool macro in Excel that accesses a bunch of Word documents in a specified directory, and pastes all the bookmarks of each document across a row of cells. It's really neat!
Anyways, it works on one of my PCs, but on my main one, it doesn't.
I get the following error:
Run-time error '-2147221231 (80040111)':
Automation error
ClassFactory cannot supply requested class
The error happens as soon as it tries to access Word, in this line:
Set WordObj = CreateObject("Word.Application")
I have seen a similar error on a colleague's PC when one of his Access apps tries to access Outlook.
A search throughout the 'net has shown me that I'm not the first person to experience this in various Word apps.
My intuition tells me that if I uninstalled Office 2003 and reinstalled it, I'd be fine.
But with all my service packs and what not, I realllly hope there is another way to solve it.
To test this macro, I have to use Remote Desktop Sharing and run it on my other machine. Not the end of the world, but very annoying!
If anyone can offer some insight or ideas, that would be amazing!!
Thanks!
Mike