ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   creating a command button (https://www.excelbanter.com/excel-programming/406965-creating-command-button.html)

CrimsonPlague29

creating a command button
 
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

Ron de Bruin

creating a command button
 
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




All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com