Help with user form - selecting more than 1 file to process
 

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

Help with user form - selecting more than 1 file to process
 

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

Help with user form - selecting more than 1 file to process
 

Thank you for your reply!

Trying to adapt it to my own needs, but struggling quite a bit!

Anyone suggest where i should put in to run my macro?

Some of the macro does rely on knowing what the open file is called.
(I've included the macro so you can see)

Thank you in advance

+-------------------------------------------------------------------
|Filename: macro.txt
|Download: http://www.excelforum.com/attachment.php?postid=4739
+-------------------------------------------------------------------

--
druce
-----------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255
View this thread: http://www.excelforum.com/showthread.php?threadid=54019