Use the Add-in
http://www.rondebruin.nl/merge.htm

Or let the user select the files (example 2)
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CrimsonPlague29" wrote in message
...
Hello,

I have used Ron de Bruin's merge files code which is working great....but I
would like to create a command button to run the macro and also allow the
user to enter the path were the files are stored as depending on what files
are to be merged and weather they are in there personal folders the path will
constantly be different....

Also is it possible to add a file later to a file that was already merged
without recreating the entire file???

Thanks