TheSwamp

Code Red => VB(A) => Topic started by: jaterrazas on March 27, 2015, 12:15:31 PM

Title: VBA common dialog controls returning "Class not Registered" error
Post by: jaterrazas on March 27, 2015, 12:15:31 PM
Get "Class not Registered" when attempting to place any of these controls onto a form in VBA 7+ 64-bit.
Title: Re: VBA common dialog controls returning "Class not Registered" error
Post by: 57gmc on March 27, 2015, 06:04:27 PM
They're probably 32 bit controls.
Title: Re: VBA common dialog controls returning "Class not Registered" error
Post by: Matt__W 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
Title: Re: VBA common dialog controls returning "Class not Registered" error
Post by: jaterrazas 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.
Title: Re: VBA common dialog controls returning "Class not Registered" error
Post by: tetrahidrocannabinol 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.