does anyone know what is wrong with this? I am trying to run 2 access macros
from excel? thanks in advance for any help on this!

Use the run command.

--
Regards,
Tom Ogilvy

"Blondie" wrote in message
...
does anyone know what is wrong with this? I am trying to run 2 access
macros
from excel? thanks in advance for any help on this!

http://support.microsoft.com/?id=177760

I doubt it supports a macro name like: "Macro1: Get Data"


--
Regards,
Tom Ogilvy


"Heather" wrote in message
...
Here's what I have but it's not working
Dim appAcc As Access.Application

'Opens Access or gets reference to app already running

Set appAcc = New Access.Application

'Optional to show or hide Access
appAcc.Visible = True

appAcc.OpenAccessProject
"P:\Analytic\Heather\Individual\IndividualTurnover Report.mdb"

appAcc.DoCmd.RunMacro "Macro1: Get Data"
appAcc.DoCmd.RunMacro "Macro2: Create Report"

'Close Access
appAcc.Quit

'This will close Access, even w/o the 'Quit' command
Set appAcc = Nothing

End Sub


"Tom Ogilvy" wrote:

Use the run command.

--
Regards,
Tom Ogilvy

"Blondie" wrote in message
...
does anyone know what is wrong with this? I am trying to run 2 access
macros
from excel? thanks in advance for any help on this!