Getting a Macro to run in a different XLS file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Macro 1
Macro from a different xls file run, still says file in use 3
Run code from another workbook 7
Running macro operations in serial fashion 6
Macro shortcuts are running macros in different open workbook 3
Automate Open an XLS without running macro 2
XLSM to XLS conversion 1
coverting all *txt files in a folder to formatted .xls files 2

Back
Top