I am using Excel 97.


I have the following task. I wanted to ask first before I try it.

I need to create a screen. The screen will have two list boxes. One
list is will have a list of available spreadsheets to be processed.
The next list box will be empty.

The user needs the ability to move the spreadsheets in the "To Be
Done" list over to the empty list box. The end user wants a command
button and the ability to drag and drop. Then when the user moves over
the spreadsheets to the "To Be Done List" list box. They hit a command
button that will trigger a macro that will run against the files in
the "To Be Done " list box.

The point is to create a list of file names to apply the macro to from
an available list.

Is this possible in Excel 97.