Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control of Access Accounts Dimensions via VBA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I access control properties? | Excel Programming | |||
Control Access | Excel Discussion (Misc queries) | |||
access excel control from vb.net | Excel Programming | |||
Access control on a worksheet - help! | Excel Programming | |||
Excel VBA To Control Access | Excel Programming |