Getting a Macro to run in a different XLS file
 

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

Getting a Macro to run in a different XLS file
 

Look at Application.Run

--
Regards,
Tom Ogilvy

"Michele" wrote in message
...
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