Hi Paul,

In Excel Visual Basic Editor you'll have to add a reference to the
Access Object Library: Tools References Microsoft Access Object Library

The general format is as follows:

Sub AccessMacro()

Dim ac As Access.Application
Set ac = New Access.Application

ac.Visible = True

ac.OpenAccessProject ("S:\FINOPS\Data\TransQuery.mdb")

ac.DoCmd.RunMacro "DailyImports"

ac.Quit

Set ac = Nothing

End Sub

Not really my macro. Copied pretty closely from Excel & Access
Integration by Michael Alexander. Hope it helps.