Results 1 to 7 of 7

Thread: Run Access Macros From Excel Or Run A Macro In MS-Access From Excel VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Junior Member bobdole22's Avatar
    Join Date
    Aug 2013
    Posts
    7
    Rep Power
    0
    Apologiez for the cross-post. Won't happen again. Although even after adding the reference the code still won't run all the way through. It stops right at

    appAccess.DoCmd.RunMacro "qry_MakeTrustTable_Adhoc"

    and displays a blank pop up box. Could it be a warning? It also doesn't do any of the code afterward. I double check the macro name and that is not the problem. He is a screen shot of the pop up I get.
    Attached Images Attached Images
    "My common sense is tingling!" - Deadpool
    For more: http://marveldcforum.com

Similar Threads

  1. Export data from Excel to Access Table (ADO) using VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-24-2015, 07:53 PM
  2. Replies: 1
    Last Post: 06-18-2013, 07:46 AM
  3. Replies: 7
    Last Post: 05-09-2013, 11:16 PM
  4. Selecting workbook to run macro
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 08-24-2012, 08:21 PM
  5. Click Run cycle
    By PcMax in forum Excel Help
    Replies: 6
    Last Post: 11-01-2011, 04:50 AM

Posting Permissions

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