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

You could drives in a dropdown, but the file would have to be in the same
spot on each.
Will a dialog work for you?

Application.Dialogs(xlDialogFindFile).Show
They can select the drive and file
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"F6Hawk" wrote:

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

Yes, the files necessary will always have to reside in the same folder, that
is a given. Typically, the files will be on a USB stick (as the RAWDATA text
files come from one computer system, then will be transported to a WinXP
system for Excel manipulation), and that is why the need for variance in
drives.

I am not familiar with a dialog, I will look into this. Thanks for the reply!

"John Bundy" wrote:

You could drives in a dropdown, but the file would have to be in the same
spot on each.
Will a dialog work for you?

Application.Dialogs(xlDialogFindFile).Show
They can select the drive and file
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"F6Hawk" wrote:

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