System error "&H80040111 (-2147221231) Class factory cannot supply requested class (1 Viewer)

System error "&H80040111 (-2147221231) Class factory cannot supply requested class

In my company we have built a custom Excel add-in using Excel 2007. We have 2 virtual environments that different computers are operating in - 1 is in Windows 7 and the other is Windows Server 2008 R2. Both are running Office 2007 though. When we install the ribbon on a computer using the Windows 7 environment it works well. When we install the ribbon on a computer using the Windows Server 2008 R2 environment though it does not work and we receive the following error: system error "&H80040111 (-2147221231) Class factory cannot supply requested class. Does anyone have any idea if it is because we are in 2 different operating systems? Is there a way to save the ribbon so it is backwards compatible between both systems or will we need to build a second ribbon, this time in the server environment?

Thank you in advance for any help you can provide!

Re: System error "&H80040111 (-2147221231) Class factory cannot supply requested clas

That is a tough one! Can you be more specific on the Win 7 OS (32 or 64 bit) and on Server 2008.
Also, the MS Office, is it 32 bit/64bit
If the MS Office on Win 7 is 32 bit and the Server is 64 bit, remove it and have them install 32 bit Office so they are exactly the same.
There are considerable issues with Office 64 bit for the very few features it offers.
My environment is the same, we develop on Win 7 in Access and use Excel Automation to create every report (in Excel). The Citrix Client is Windows Server 2008 R2. It is important to keep the environment much the same.
It is also important to look at the Tools References in the code modules of each.
An update for Outlook for example can secretlly update a Reference version in Office and ruin the day.

Re: System error "&H80040111 (-2147221231) Class factory cannot supply requested clas

Hi - sorry for the delayed response! I am not 100% positive of what version of Windows 7 we are running because everything is pretty locked down on our computers by the system administrators.

I did try to find a workaround for the error, thinking that Windows Server didn't like the add-in being added into the ribbon by creating a simple workbook that holds all of the VBA code and functions the same way as the actual add-in. However, on the Windows Server computers the system error is still popping up. I have deleted the add-in from the computer and out of the add-ins folder but there still is an error popping up. Any idea how to fix the error?

Thank you!