Hi everyone,
I hope someone can help me. I have an Excel 2016 macro on Win10 that is not working for me. The following VBA line is raising an error that says "(Class not registered)"
Please Login or Register to view this content.
Anyone know what needs to be done to correct this? Please.
Last edited by alansidman; 07-02-2020 at 01:18 AM.
welcome to the forum
For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
I have changed the title for you today. Please read the rules and abide by them in the future.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Are you using 32 or 64bit Office? Which references do you have set in the VBA Project?
Everyone who confuses correlation and causation ends up dead.
Hi, I'm using 64 bit office, and these are the references:
Visual Basic For Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library
Ref Edit Control
Microsoft DAO 3.6 Object Library
Microsoft Access 16.0 Object Library
DAO3.6 is not compatible with 64bit Office. You need to replace it with the Microsoft Office 16.0 Access Database Engine Objects library instead.
Re: VBA Error (Class Not Registered)
Thanks Rorya,
Looks like i have some rewriting to do as the existing code using DAO has statements such as dim db as Database and dim rs as recordset which at first glance seems to not supported with the replacement reference.
Hopefully it won't be too painful.
Once again, thanks!
They should be supported. You shouldn't need to change any of the code. If you're having an issue, I suspect you selected the wrong reference (and of course you need to remove the DAO3.6 reference)
You were correct Rorya, I had the wrong reference. Some of those reference names are so similar. Now it works and I don't have any painful rewriting to do. Super duper thanks.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks, I didn't know where to mark it solved. So now it's marked solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks