vb6 1

[Guest_imported]

How do I execute an access macro from inside my vb6 project with out user intervention?

If you can help thank you!

 

[chogben]

You could cheat and start access with the shell command using the command line argument of /x <macroname>.

Just a thought...

 

[kevinclark]

Could also try something like the following:

You will first need to set a reference to the Microsoft Access 9.0 Object Library under the Project Menu (VB 6) or the Tools menu (MS Excel etc Module window)



Sub Button1_Click()
Dim ac As Access.Application
Set ac = New Access.Application
ac.OpenCurrentDatabase (&quot;C:\Development\Database\TEST\TEST.mdb&quot

'Use to run a Macro
ac.DoCmd.RunMacro &quot;MACROTEST&quot;
' or
'to run a function in a module
ac.Run (&quot;testMe&quot


ac.CloseCurrentDatabase
End Sub