Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    How to copy a file from Excel VBA

    I need a solution to copy a file from a network drive from Excel VBA. From DOS, this would be: "copy g:\jerry\export.zip c:\data\zippedfiles".

    Thanks.
    Jerry

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    I found a solution to copy files from VBA:

    Dim SrceFile
    Dim DestFile

    SrceFile = "g:\jerry\export.zip"
    DestFile = "c:\data\zippedfiles\export.zip"
    FileCopy SrceFile, DestFile

    This one has been solved.
    JD

Posting Permissions

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