+ Reply to Thread
Results 1 to 2 of 2

Shell command to rum dos copy command on vba

  1. #1
    Registered User
    Join Date
    01-24-2009
    Location
    MODENA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Shell command to rum dos copy command on vba

    if i put in a cell r1 a path OF a file and in a cell n2 a destination path How can i run a shell command on vba

    R1=foglio1!r1.value
    N2=foglio1!n2.value



    Shell cmd /c copy &R1 &N2 ,0

    Brut IT DOES NOT FUNCTION

  2. #2
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Shell command to rum dos copy command on vba

    Hi..

    Put Source value in R1 (example: H:\test.txt). and then the Destination value in N1 (example: G:\)..
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shell command in VBA ?
    By RustyNail in forum Excel General
    Replies: 3
    Last Post: 04-26-2015, 10:46 PM
  2. 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
  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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1