We found this great article on Stephen Smith's blog & would like to share it with you.
by Stephen Smith (http://smist08.wordpress.com)
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