ROBOCOPY - Incorporate to excel VBA

[Motestfilter]

Hi,

I am thinking of incorporating the ROBOCOPY with excel since I am doing a lot of file transfers. I just have no idea where to start. I would like to be able to enter a source and destination path into a cell then maybe some radio button or any kind of selection depending on what specific switch I want to enable. After inputting the paths and selecting the switch it could either create a .bat file to run it or run the command directly to the CMD window.

ROBOCOPY has a pretty simple syntax -

 [FONT=Fixed, monospace][COLOR=#454545]ROBOCOPY "sourcepath" "destinationpath" [switches] [/COLOR][/FONT]

So basically it is running command line that was generated in excel to the CMD window.

Any direction would be helpful. Thanks!

 

[Joe4]

Perhaps one of these old threads might help:
https://www.mrexcel.com/forum/excel-questions/475360-robocopy-excel.html
https://www.mrexcel.com/forum/excel-questions/849251-copy-files-one-folder-another-using-vba.html