Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy a whole folder (excel97)

    I would like to copy the contents of a whole folder into a different folder
    I have been using FileCopy to copy just one file

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: copy a whole folder (excel97)

    Check out the code at VBA Visual Basic for Applications (Microsoft) FAQ - Tek-Tips which uses the FileSystemObject.

    Steve

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy a whole folder (excel97)

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    thank you very much
    it works perfectly

Posting Permissions

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