Calling a Access 2000 Macro within VB6

[moben]

Does anyone know how to call and run a Access 2000 macro from within a VB6 application.

Any help appreciated,

Regards,

Moben.

 

[strongm]

DoCmd.RunMacro

 

[abaldwin]

To further strongm's suggestion you first need to open an instance of Access. Check out the following page

http://www.veign.com/vrc_codeview.asp?type=app&id=120

I think it does EXACTLY what you are asking.




Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[moben]

Thank you Andy and StrongM,

Your advice was taken and desired results has been achieved.

One question, how does one switch off Access prompts, when running a Access macro from within VB6 ?

e.g. If I run Macro from within Access, I get prompted to "File already exists, do you wish to overwrite ?".. and yes I do.

If I run the Macro from VB6, how can I pass a 'Yes' to the prompt (not that its being displayed), but the Macro copies data from a Access table to a Excel spreadsheet.

All works fine, but if I open the Excel spreadsheet, and the Macro is run from within VB6, the timestamp of the Excel file does not change i.e. it appears the macro is not working, or though a message for overwriting is not displayed, it is defaulting to a 'No' I do not wish to overwrite the original file. This is not what I want.

Regards,

MoBen.

 

[abaldwin]

I believe that in the macro you can setwarnings = off


Andy Baldwin

"Testing is the most overlooked programming language on the books!