Results 1 to 1 of 1

Thread: Robocopy VBA

  1. #1

    Robocopy VBA

    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi, i got this code from vba forum by SO but it did not worked on my pc could you please help

    i have attached the excel where i have mentioned the details in sheet1 and in sheet2 the screenshot of command prompt. many thanks in advance

    Sub SO()      
        Const Q As String = """" 
        CreateObject("WScript.Shell").Run "CMD /C ROBOCOPY " & Q & Range("A6").Value & Q & " " & Q & Range("C6").Value & Q, False, 0 
    End Sub
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts