Running Macros in Access from Excel
 

Hi,

Is there nayway to write some script in Excel that opens
Access, runsa pre-recorded macro and then closes Access?
I also want this to be invisible to the user.

Many thanks in advance,
Simon

Running Macros in Access from Excel
 

You can do something like this:

Sub ljd()

Set db = GetObject("C:\DatabasePath\DatabaseName.mdb")
db.DoCmd.RunMacro ("SampleMacro")
db.Quit
Set db = Nothing

End Sub

tod

-----Original Message-----
Hi,

Is there nayway to write some script in Excel that opens
Access, runsa pre-recorded macro and then closes Access?
I also want this to be invisible to the user.

Many thanks in advance,
Simon
.