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" <(E-Mail Removed)> wrote in message
news:04429BF6-5465-4834-884C-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:0BA99458-FDBC-4D54-9D83-(E-Mail Removed)...
> 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\IndividualTurnoverReport.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" <(E-Mail Removed)> wrote in message
>> news:04429BF6-5465-4834-884C-(E-Mail Removed)...
>> > 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!
>>
>>
>>