Run Access Macro


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Run Access Macro

  1. #1
    Bob Guest

    Run Access Macro


    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

  2. #2
    Ralph Guest

    Re: Run Access Macro


    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



  3. #3
    Paul Clement Guest

    Re: Run Access Macro

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center