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

[Excel Fox]

Are you sure
qry_MakeTrustTable_Adhoc exists as a Visual Basic macro within that database? If yes, try this

Dim strDatabasePath As String
Dim appAccess As Access.Application
 
strDatabasePath = "C:\Users\zachk\Desktop\Strats 2011.01.accdb"
Set appAccess = New Access.Application
With appAccess
    .OpenCurrentDatabase strDatabasePath
    .Run "qry_MakeTrustTable_Adhoc"
    .Quit
End With
Set appAccess = Nothing

[edwards142]

Well dear, I can help you out in knowing how to create macros in Access with 3 different ways and how to run it. I have read this article when I was stuck in some problem with my Access macros coding. it’s really very helpful post. So, I thought you might also get some help from it.

SO TRY IT…!
3 Quick Ways To Create Macro In MS Access 2010/2013/2016/2019 Database