I have a sheet that runs macros which open text files, manipulate the data,
and give me a clean, readable output. Works great, as long as I always have
the same drive as the source.

But I want to give the user an option to choose the drive from which to pull
the data and where to put the report.

Right now, I have Modules 1 thru 4, each performing a different function,
all from the F: drive, based on the push of buttons 1 thru 4. What I would
like to be able to do is select which report to run from a list, as well as
which drive to pull from using another list, and somehow pass this info to a
macro.

The drive options I will need are A & C thru G. I COULD write a macro for
each and every SUB, hard coding the drive info, but that will result in 28
SUBs, kinda messy & bulky. If it is possible to do what I am asking, I could
pass two variables to 4 different SUBs, and open the data from whichever
drive the user selects.

Thanks in advance for your help!
Dave