Hello, we have couple of Trail Balance reports which are modified by the VBA. However, one of the reports is giving us following error while running it. Does anyone encounter this error before? If so any recommendations on how to fix it? Thanks.
What exactly your modification is doing?
Was there any recent Windows OS updates applied ?
VBA is very depending on Office updates and that's why Microsoft has stopped officially to support VBA in GP due to the impossibility for them to control the updates on VBA libraries..
What is the code supposed to do in your TB report in GP?
GP PowerTools add some true dexterity functions to GP that can be used in Report Writer and GP Forms to replace VBA code.. check it out.
www.winthropdc.com/GPPT
Basically, it's running PM historical Trial Balance report and exporting it to Excel. We have similar report running for the RM historical Trial balance and it works fine.
Thanks,
But you didn't answer a single question of mine... Please provide more details about what's failing. Any recent updates? what is the code supposed to do?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,882
André Arnaud de Cal... 794 Super User 2025 Season 2
Sohaib Cheema 525 User Group Leader
