Run Access Macro

[Bob]

Hi,

Is it possible to code a MenuCommand to run a macro within an Access
database.

I have a macro that will Copy a table, run a query and than send it to
Excel and open Exce. Once it opens Excel I'll run another Macro in Excel

that will inturn reformat it and print charts.

Thought it would be nice if I could do this within the VB app.

Thanks in advance.
Bob

[Ralph]

Yes.

Take a look at the Office Object Libraries.

If you are using Office 2000 - "Microsoft Office 2000/Visual Basic Programmer's
Guide" at the MSDN website. (Sorry I can't provide a URL at the moment -
but M$ changed things around and all my linds seem to be broke.

You can handle both Access and Excel using their respective libraries.

Beware that you can't use them to return much in the way of data, for that
you will still need to use ADO.



"Bob" <rgschumann@home.com> wrote:
>
>Hi,
>
>Is it possible to code a MenuCommand to run a macro within an Access
>database.
>
>I have a macro that will Copy a table, run a query and than send it to
>Excel and open Exce. Once it opens Excel I'll run another Macro in Excel
>
>that will inturn reformat it and print charts.
>
>Thought it would be nice if I could do this within the VB app.
>
>Thanks in advance.
>Bob

[Paul Clement]

On 26 Jul 2001 11:41:55 -0700, "Bob" <rgschumann@home.com> wrote:

¤
¤ Hi,
¤
¤ Is it possible to code a MenuCommand to run a macro within an Access
¤ database.
¤
¤ I have a macro that will Copy a table, run a query and than send it to
¤ Excel and open Exce. Once it opens Excel I'll run another Macro in Excel
¤
¤ that will inturn reformat it and print charts.
¤
¤ Thought it would be nice if I could do this within the VB app.
¤
¤ Thanks in advance.
¤ Bob

See if the following helps:

http://support.microsoft.com/support.../q177/7/60.asp


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)