Consulting

Results 1 to 2 of 2

Thread: copyfolder

  1. #1
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location

    copyfolder

    Hello

    Every time i use the copyfolder method as :-

    Set MyFolder = fso.CreateFolder("C:\MyDocs\ReportingDatabase" & "\" & SaveDate) MsgBox "The folderWas created"

    fso.CopyFolder "C:\MyDocs\Reporting Database\Reports","C:\MyDocs\Reporting Database" & "\" & SaveDate

    it copies the contents of the folder rather than the folder itself

    the file structure within Reporting Database there is a subfolder called Reports. I create a new subfolder within Reporting Database and give it the name of the reporting date which i have saved to a variable SaveDate. Within this new subfolder i want to copy the folder Reports and put it here for a new set of reports to be generated. So Reporting Database will have a subfolder for the new reporting date within which there is a subfolder called reports which is a copy of another folder.

    any ideas

    thanks
    phil

  2. #2
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location
    Any help guys???

    Cheers
    Phil

Posting Permissions

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