Thanks for reaching out to the Community, Letajay.
Since you're encountering a Microsoft Visual Basic for Applications error while trying to open your Certified Payroll report in Journeyworker and Apprentice, I'd recommend getting in touch with their support team. They'll be able to help you look further into why the error's being displayed.
I've also included a detailed resource about working with reports which may come in handy moving forward: Export reports as Excel workbooks
Please don't hesitate to send a reply if there's any additional questions. Have a wonderful Friday!