+ Reply to Thread
Results 1 to 2 of 2

Need help launching robocopy command in Shell()

  1. 06-23-2014, 10:40 AM #1
    GeneralDisarray
    GeneralDisarray is offline
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Need help launching robocopy command in Shell()

    Hello,

    I'm having trouble lauching the robocopy command using Shell()

    Please Login or Register  to view this content.
    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??


    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.
    Last edited by GeneralDisarray; 06-23-2014 at 11:20 AM.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  2. 06-25-2014, 07:14 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help launching robocopy command in Shell()

    Thanks for posting the solution.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using macro to execute a command in Shell Command
    By aadarsh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2010, 07:06 PM
  2. Shell command help
    By ramathiam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2007, 10:37 PM
  3. shell command
    By jtwork in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2007, 08:07 AM
  4. [SOLVED] Shell command
    By Viktor Ygdorff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2006, 12:45 PM
  5. [SOLVED] Help with shell command
    By St in forum Excel General
    Replies: 3
    Last Post: 11-04-2005, 10:45 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1