Author Topic: VBA common dialog controls returning "Class not Registered" error  (Read 6853 times)

0 Members and 1 Guest are viewing this topic.

jaterrazas

  • Guest
Get "Class not Registered" when attempting to place any of these controls onto a form in VBA 7+ 64-bit.

57gmc

  • Bull Frog
  • Posts: 365
Re: VBA common dialog controls returning "Class not Registered" error
« Reply #1 on: March 27, 2015, 06:04:27 PM »
They're probably 32 bit controls.

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: VBA common dialog controls returning "Class not Registered" error
« Reply #2 on: March 27, 2015, 09:00:47 PM »
The OCX or DLL file may need to be registered.

http://www.ctimls.com/Support/KB/How%20To/Register_dll.htm
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

jaterrazas

  • Guest
Re: VBA common dialog controls returning "Class not Registered" error
« Reply #3 on: April 02, 2015, 11:16:23 AM »
Either wiaaut.dll or comdlg32.ocx or which file needs to be registered?  I had never heard of wiaaut.dll but VBA says it is the CommonDialog Class; I'm familiar with comdlg32.ocx from prior development.
By the way, both of these are sitting in the ..\Windows\system32 folder which leads me to believe that they are both 64-bit.

I'm already familiar with registering these types of files and just prior to posting this was able to successfully register both of them only to get the same "Class not Registered" message.

tetrahidrocannabinol

  • Guest
Re: VBA common dialog controls returning "Class not Registered" error
« Reply #4 on: April 09, 2015, 11:57:35 PM »
comdlg32.ocx is a 32-bit library.

You can not load/call a 32-bit library from a 64-bit application and viseversa.