We help IT Professionals succeed at work.

VBA Class Not Registered

I have a windows 10 64bit system that we have 64 bit Solidworks installed on it and utilize a bunch of VBA based macros on it.  

I have always installed 32bit Office 365 on our systems, but accidentally installed the 64bit version and then the macros didn't work even though they have been changed to 64bit many years ago.

So, I uninstalled 64bit Office 365 and reinstalled the 32bit version but now i am getting this error when trying to run the macro's.....

Can someone please help me identify what I need to re-register to get these working again

Thanks

Denten
Class Not Registed
Comment
Watch Question

ste5anSenior Developer

Commented:
So your SolidWorks macros worked until you've installed a different Office version?

Sounds like you need to do a clean reinstall of both packages. But you may try an Office repair installation first. The problem is, that this CLSID points in no clear direction. It has something to do with Office, but it's not clear after asking the oracle.
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
No clue if this will help, but you may lioke to look over

https://support.microsoft.com/en-ca/help/961568/error-message-when-you-start-microsoft-dynamics-gp-errors-occurred-dur

OR

https://www.mathworks.com/matlabcentral/answers/416123-how-to-resolve-the-issue-that-spreadsheet-link-add-in-in-excel-is-causing-class-not-registered

The solution is simply trying to re-register a system dll, may be worth a try only take a minute.  The 2nd link include the 64-bit instance path.

Author

Commented:
on every other computer system where I installed office 365 as 32bit only they have always worked.  

I never realized that Office 365 changed the default for install from 32bit to 64 bit and accidentally installed the 64bit version the other day.

I tried repairing office as well as uninstalling and re-installing both pieces of software but the error still remains...

Author

Commented:
Hi Daniel,

I reviewed your links and attempted the suggestions.  FM20.DLL was in system32 folder.  I was able to un-register it but when i try to re-register it i get the attached error message.

I then tried copying to SYSWOW64 folder and registering again, but received the same error....
IMG_7148.jpg

Author

Commented:
disregard my last comment....

I thought i was in Command prompt as administrator, but maybe i wasn't.... exited Command prompt and re-entered as Admin

re-ran the register on FM20.dll and it accepted it.

error in Solidworks went away!

Thanks for your help!