Hello,
I'm having trouble lauching the robocopy command using Shell()
The switches I want to use are /E /MIR /COPY:DAT. Can anyone tell me what I'm missing? I've only used Shell() within VBA sparingly, maybe i need a full path to the Robocopy executable??Sub UseRoboCopy(networkTemplates As String, localTemplates As String, switches As String) Shell ("robocopy " & networkTemplates & " " & localTemplates & " " & switches) End Sub
Please help
-----------------------
Sorry folks, I just had a typo in the paths... this totally works.
If you are having trouble distributing updates of a common workbook, I would suggest using "robocopy" to copy a master template file out to the field users.
Bookmarks