shell roboCopy 'not recognized as internal or external command, operable program or batch file' error

[john316swan]

I am looping through a connection to sync folders from a network drive onto a google drive and I can't figure out why cmd is giving me:
'robocopy' is not recognized as an internal or external command, operable program or batch file." error

Here is my code:

'Here we can run the batch files to ROBOCOPY athletic offer letters to coaches
For Each item In ath
    sourceCopy = """X:\Financial Aid – Athletics\2020-2021 Offer Letter & CW\" & item & """"
    RoboCopy = """G:\My Drive\AthleticOfferLetter\" & item & "\2020-2021" & """"
    shellCommand = "cmd /c robocopy " & sourceCopy & " " & RoboCopy & " /XO"
   Call Shell(shellCommand, vbMaximizedFocus)
Next item

When I run the command line without the vba loop, it successfully copies those folders, but can't get the vba shell command to work properly. Thanks for your help!

@DanteAmor haha, since you usually are able to help, just tagging you up front

 

[john316swan]

*I am looping through a collection not connection just in case someone starts wondering.

When I debug.print the sourceCopy & RoboCopy & " /XO" in the immediate window, I can copy that string and manually run a command line robocopy and it works, but can't get the code to work.

 

[john316swan]

I was determined to fix it quickly, but I had a meeting...finally solved it on my own yay me.

'Here we can run the batch files to ROBOCOPY athletic offer letters to coaches
For Each item In ath
    sourceCopy = """X:\Financial Aid – Athletics\2020-2021 Offer Letter & CW\" & item & """"
    RoboCopy = """G:\My Drive\AthleticOfferLetter\" & item & "\2020-2021" & """"
    shellCommand = "cmd /c cd ""C:\Windows\System32"" && robocopy " & sourceCopy & " " & RoboCopy & " /XO"
   Call Shell(shellCommand, vbMaximizedFocus)
Next item

I had to change the directory to where roboCopy was stored in my system (cd ""C:\Windows\System32") before I ran robocopy and then I figured out how to separate shell commands using "&&" before I ran robocopy.