Run Access VBA Script from Excel

[Hanz77]

Every day I run a VBA script in Excel. As soon as the Excel script is done running, I open Access and run another VBA script. I would like to add something at the end of my Excel VBA script to run the VBA script in Access. Any thoughts on how to do this? I am using Office 2007.

 

[RoryA]

Something like:

   Dim objaccess As Object
   Set objaccess = CreateObject("Access.Application")
   objaccess.AutomationSecurity = msoAutomationSecurityLow
   objaccess.OpenCurrentDatabase "C:\mypath\mydatabase.accdb"
   objaccess.Run "macro name"