I need some help with argument passing....

I have a macro (let's call it TEST()) that I will run from a Master
file. The results will go in seperate files.

The macro TEST() would be the same for each file with the exception
that the file name would change
ex : Windows("Rider.xls").Activate

the rest of the macro (TEST()) does not varie from file to file.
So from my master file I would have calls to this macro (TEST()) and
pass the name of the file I want to generate (eg. Rider1, Rider2,
Rider3, ect.)

I could then simply call Windows("STRING").Activate from the macro .
STRING being the string I would pass from the master file

What is the easiest (or pretiest) way to do this?


thanks

Pabs


---
Message posted from http://www.ExcelForum.com/