Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
shadowlakeranch
Level 1

QB Certified Payroll Report - MS Visual Basic Compile error in hidden module.

Before anyone gives me the basic advice... here is what we have already tried.

 

Calling QB support

Updating QB and Office

Disabling Add in's

Disable VBA macros with notification

Revert to a previous version of office when it used to work.

Fix data damage

Complete reinstall of Office.

 

This issue happened back in 2023 after an update. Didn't get resolved till QB updated again.

 

Quickbooks, you need to fix this

2 Comments 2
Letajay
Level 1

QB Certified Payroll Report - MS Visual Basic Compile error in hidden module.

I'm having the same issue, when I called into Quickbooks I was told the only way to get the report to work is to upgrade to Desktop Enterprise. Hopefully someone can come up with a solution!

BigRedConsulting
Community Champion

QB Certified Payroll Report - MS Visual Basic Compile error in hidden module.

I reviewed the old and new versions of the report template. Intuit glammed up the main interview form and added some things to it, presumably because the DOL requirements changed. Not sure.

 

Likely Problem

In the process Intuit added a new way for the report to break, which is probably what is behind the errors you're seeing. They added a code reference to "Microsoft Windows Common Controls 6.0" in order to make some additional forms controls, like buttons and fields, available. And then they wrote a bunch of rather complex code to dynamically update the display of the interview.

 

Microsoft Windows Common Controls 6.0 is not part of MS Office, but instead part of Windows. It is also the only referenced ActiveX control and it is old and out of date. On one of my computers it's from 2002!

 

I asked Google "Does Microsoft Office install MSCOMCTL.OCX" and it answered:

  • No, Microsoft Office typically does not install MSCOMCTL.OCX with recent versions, especially with 64-bit Office, as it's an outdated ActiveX control not included in Click-to-Run installations.
  • MSCOMCTL.OCX is from an older era of Windows and Office development and isn't part of modern installations.
  • Current Office versions use a "Click-to-Run" deployment, which runs in a virtualized system, and this doesn't include the control.

 

Congratulations Intuit! In your update you managed to lean into and add a dependency on some ancient tech that's not even installed with Office. Excellent choice!

 

If your computer it is somehow missing MSCOMCTL.OCX or it is not registered properly, then you'll get a compile error with the new version of the report when you didn't before.

 

The Common Controls file is at C:\Windows\SysWOW64\MSCOMCTL.OCX for 64-bit Windows versions. If you don't see it there, then that's the issue.

 

Likely Solution

If you don't have the file in that location, or even if you do and it's not working, you can download and install the latest version of it from this page: Microsoft Visual Basic 6.0 Common Controls

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us