Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    42

    Unanswered: Run excel macro from access

    I have a button to run a report in Access. That button runs a cross-tab query that then gets exported to excel. Excel opens, but then I would like it to automatically start a macro (or VBA code) that does some formating. Is there a way to have access run an excel marco?

    Please...Help!

    Thanks,
    Noobie

  2. #2
    Join Date
    Feb 2004
    Posts
    42
    I guess I answered it myself, but I thought I would post it in case anyone else was wondering. I doubt this is the most effective way to do this, but I used the SendKeys feature. Once exported to excel, with Excel as the selected (maximized, with focus) program, I used the SendKeys to enter the keys that would run the Macro in excel (specifically ctl-shft-p).

    I think it will work...Let me know if there is a better way.

    Thanks,
    Noobie

  3. #3
    Join Date
    May 2004
    Posts
    10

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •