Ron de Bruin has some code that may help you get started on this.
http://www.rondebruin.nl/ado.htm#files

Mike F
"drucey" wrote in
message ...

Hi EF,

Well, i've spent a month now doing a macro, and very happy with it -
it works!

Basically it opens up a "Select file" box, you choose the file, then it
runs 200+ lines of macro on it.

But i want to see if i can make it a bit more user friendly, by using a
userform and allowing the user to select more than 1 file - queue them
up perhaps, then run the main macro on them, one by one.

Not necessarily needing a userform, i'm not sure, but a bit lost on
what to do next.

Any help would be great, thank you!


--
drucey
------------------------------------------------------------------------
drucey's Profile:
http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=540190