run Macro from command line

[vaibhav_patel]

hi!

Can anyone tell me how to run the macro from command line without opening the Ms Access application.

I want to add the Macro command in my batch file. And I don't want toopen the Access Framework. I am running Macro using this command.


"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" c:\drug_mlt\drug_mlt.mdb /runtime /nostartup /excl /x export_table

Using this command Ms Access framework is opening and it is exporting the tables. so it shows the progress bar on the status bar. But after the Macro finish i need to close this application. I don't want to run the Macro without opening Access Framework.

Any suggestion.

Thanks in Advance

 

[mdmilner]

You could try a DOS Kill Proccess_Name technique inside the batch file.
You could also use something like

Application.Quit

Inside the "Macro" at the end.

Mike