<div>
Why do you want to use ADO connection?<br />
<br />
You should be able to run the Access macro by opening the access database in excel and DoCmd.Run command or something like that.
</div>


Why do you want to use ADO connection?

You should be able to run the Access macro by opening the access database in excel and DoCmd.Run command or something like that.

<div>
thanks for the reply. &nbsp;if possible i would prefer to do it by ado. &nbsp;I feel that it uses to much overhead to open an access application just to run a macro. 
</div>


thanks for the reply.  if possible i would prefer to do it by ado.  I feel that it uses to much overhead to open an access application just to run a macro.

<div>
You can access data from Access database using ADO but you won't be able to run macros using ADO.
</div>


You can access data from Access database using ADO but you won't be able to run macros using ADO.

<div>
Not as far as I know.<br />
<br />
I think you have to use automation.<br />
<br />
Dim objAcc As Access.Application &nbsp; &nbsp;<br />
On Error Resume Next &nbsp; &nbsp;<br />
Set objAcc = GetObject(, &quot;Access.Application&quot;) &nbsp; &nbsp;' if access is open<br />
If Err.Number &lt;&gt;&nbsp;0 Then &nbsp; &nbsp; &nbsp; &nbsp;<br />
Set objAcc = CreateObject(&quot;Access.Appli<wbr />cation&quot;) &nbsp; &nbsp; &nbsp; &nbsp;' if not..<br />
objAcc.OpenCurrentDatabase<wbr /> &quot;C:\databasename.mdb&quot; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp;End If &nbsp; &nbsp;<br />
objAcc .docmd.runmacro &nbsp;(&quot;macroname&quot;) &nbsp; &nbsp;<br />

</div>


Not as far as I know.

I think you have to use automation.

Dim objAcc As Access.Application    
On Error Resume Next    
Set objAcc = GetObject(, "Access.Application")    ' if access is open
If Err.Number <> 0 Then        
Set objAcc = CreateObject("Access.Application")        ' if not..
objAcc.OpenCurrentDatabase "C:\databasename.mdb"        
 End If    
objAcc .docmd.runmacro  ("macroname")    


<div>
<div class="content wysiwyg-content">
Is it possible to run an Access macro inside of excel using an ado connection?
</div>
</div>


Is it possible to run an Access macro inside of excel using an ado connection?

Run an MS Access macro using an ado connection

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.