Avatar of Denten McDougall
Denten McDougall
Flag for Canada asked on

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
Windows 10Microsoft OfficeMicrosoft 365Windows OSVBA

Avatar of undefined
Last Comment
Denten McDougall

8/22/2022 - Mon
ste5an

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.
ASKER CERTIFIED SOLUTION
Daniel Pineault

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Denten McDougall

ASKER
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...
Denten McDougall

ASKER
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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Denten McDougall

ASKER
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!