Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009

    Question Unanswered: Trouble displaying access table in excel macro

    I have an Access macro that runs a query. This macro functions fine in Access. I would like to run it in an Excel macro (I've very little vba knowledge and clipped what I could online). The macro I have in Excel consists of a userform that runs my Access macro/query when the user clicks a button- it requests the parameters, but then no results are displayed (the same macro produces a data table in access). I don't know if I need to add something to my Access macro or to the Excel macro to fix this, but the access guys told me it's an excel thing. Here is what I have on the Excel macro:

    Sub TrackingMultiple()
    Dim A As Object
    Application.DisplayAlerts = False
    Set A = CreateObject("Access.Application")
    A.Visible = False
    A.OpenCurrentDatabase ("P:\equityShared\rw\sales\Structured Equity Solutions\Institutional Coverage\Business Planning\Tracking.mdb")
    A.DoCmd****nMacro "SearchMultipleFields"
    Application.DisplayAlerts = True
    End Sub

    Any help would be much appreciated!

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    One thread per question please, Sweetie.
    If anyone would like to help, please do so here:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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