Getting a Macro to run in a different XLS file

[Michele]

I've created a formatting macro that runs beautifully called "Export Macro"
located in the file "Macro 2006.xls". I want to make "Export Macro" run in a
separate file called "Presubmission.xls". This file is generated by Access,
located in the same spot with the same title (for grins, let's say the path
is: \\svr1\Common\MI\Frustration\Presubmission.xls)

Ultimately, I want to link the "Export Macro" to a command button in "Macro
2006.xls", which tells it to go the "Presubmission.xls" and run "Export
Macro", thereby formatting my report.

What is the code I need to have to accomplish this? I've tried a few
different things, but am still somewhat new a macro writing.

Any help would be appreciated!

Thank you,
Michele

[Tom Ogilvy]

Look at Application.Run

--
Regards,
Tom Ogilvy

"Michele" <[email protected]> wrote in message
news:[email protected]...
> I've created a formatting macro that runs beautifully called "Export
Macro"
> located in the file "Macro 2006.xls". I want to make "Export Macro" run
in a
> separate file called "Presubmission.xls". This file is generated by
Access,
> located in the same spot with the same title (for grins, let's say the
path
> is: \\svr1\Common\MI\Frustration\Presubmission.xls)
>
> Ultimately, I want to link the "Export Macro" to a command button in
"Macro
> 2006.xls", which tells it to go the "Presubmission.xls" and run "Export
> Macro", thereby formatting my report.
>
> What is the code I need to have to accomplish this? I've tried a few
> different things, but am still somewhat new a macro writing.
>
> Any help would be appreciated!
>
> Thank you,
> Michele