View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] stuartbisset@gmail.com is offline
external usenet poster
 
Posts: 4
Default Control of Access Accounts Dimensions via VBA

Hello All

Access Accounts Dimensions (hereafter "AAD") is a piece of accounting
software (www.access-accounts.com) used by mid-tier companies and is
not to be confused with MS Access.

I would like to know if anyone out there is using this software and is
using the Access Office Integration (AOI) functionality to import
their data from AAD into Excel.

I want to know if there are any VBA commands available to control AAD
via macros - eg to refresh a table. If there are many tables in a
workbook the user has to click into each of them and hit refresh. I
would like to create a button that will do this for them.

I am also interested in any other VBA commands that are available for
controlling AAD. Does anyone have a guide?

Many Thanks

Stuart