Ms Access Execute Function

[Gintaras]

Menu Tools -> COM libraries,
find Microsoft Access ... Library,
double click it,
Close.

Macro Macro2769

Code:

Copy      Help

typelib Access {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} 9.0

Compile the macro.
Type Access, dot, and select Application from list. Declare a variable.
Call its member function _getactive. Or _getfile, but it probably creates new hidden msaccess process.

If Quick Macros is running as Administrator or uiAccess, let the macro run in separate process as user.

Whole macro
Macro Macro2769

Code:

Copy      Help

;/exe 1
typelib Access {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} 9.0
Access.Application oApp._getactive
VARIANT v1=123 ;;need a variable because QM cannot pass constant values to ByRef parameters
oApp.Run("QM_Test" v1)

;BEGIN PROJECT
;flags  6
;END PROJECT