BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

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

5 Comments 5
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

kfil1
Level 2

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

If you haven't found a solution to this yet  - after wasting hours trying to resolve this I finally just uninstalled and reinstalled Quickbooks Enterprise Desktop (if it matters, contractor 24.0) It worked. This is the solution. Not the QB hubb tool, not "sending my file to QB tech support for repair" as they requested, not an MS office issue. Just uninstalling and reinstalling QB Desktop. Good luck!

plumb524
Level 1

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

Same thing happened to me.,,,still not working.

AdonL
QuickBooks Team

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

Hi, @plumb524. Thank you for chiming in on this thread. As a QuickBooks user myself, I understand how challenging it can be when reports aren't functioning as expected.

 

If you've already tried the solutions mentioned in this thread about the QuickBooks Certified Payroll report issue, I recommend contacting our live support team. They can perform a detailed analysis of your system, identify any underlying issues, and provide a tailored solution to ensure the reporting feature functions correctly. 

 

To ensure prompt assistance, check out their hours of availability in this article: Get help with QuickBooks products and services.

 

I'm committed to resolving your concern, @plumb524. Please comment below for further assistance.

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

Need to get in touch?

Contact us