View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Copy a folder's contents into another folder?

Consider the following code:

FSO.CopyFolder "C:\MyData" "C:\Backup"

This will create a NEW folder named "Backup" which has the identical
contents of "MyData".

For my purposes, suppose the "C:\Backup" folder already exists, and
my goal is to copy the "MyData" folder INTO the "Backup" folder.
Is this possible with the "CopyFolder" function?

Also, does Excel provide other functions or means for copying
and pasting folders?

Thanks!