Control of Access Accounts Dimensions via VBA

[stuartbisset]

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

 

[StuartBisset]

Have subsequently come to the conclusion that AOI is useful for ad-hoc
reporting but is of little use if, like me, you are trying to create a
seamless excel application that is user friendly. I have now gone
down the route of grabbing data via ODBC.

Access-Accounts seem to have gone to great lengths to allow
connectivity with Excel but have fallen at the final hurdle by failing
to supply a reference library with useful VBA commands for controlling
their software. I also found out during my investigations that the
Access Functions (ie excel formulae) for linking back to your database
are dreadfully slow if you have more than a few hundred (easily done).

Therefore ODBC is by far the quickest and most flexible option.

Please do get in touch if you are a business also struggling with this
dilemma when developing your reporting, forecasting & consolidation
models.

Kind regards

Stuart Bisset BA CA