Insights & Information regarding enterprise resource planning software from a leading industry

Sage ERP Accpac Macro Tips & Tricks

Posted by Alison Boons on Fri, May 14, 2010 @ 02:47 PM

We found this great article on Stephen Smith's blog & would like to share it with you. 

by Stephen Smith (

Sage ERP Accpac uses Visual Basic for Applications (VBA) as its macro language. This is the same macro language used by Microsoft office & many other Windows desktop applications. With VBA Macros you can access the Accpac Business Logic laryer & enter documents, perform processing like posting batches or print reports. Since every screen in Accpac is an ActiveX control, you can embed any screen in a VBA macro & then manipulate/customize it in a standard uniform manner. Writing VBA macros is a huge topic; there are many books available on the topic along with courses at Sage University on VBA specifically for Accpac. This blog posting just lists a few useful tips & tricks that people find helpful when programming Accpac macros. These assume a general knowledge of writing basic Accpac macros. These aren't in any particular order & tend to jump all over the place.

To read Stephen's ideas, check out the full article her

Subscribe to our blog giving us consent to send email updates

Get in Touch

Phone: 604-544-7587
Toll-free: 1866-714-7587

Subscribe to our E-Newsletter


Search blog

Follow Us

Software » Services