philfer
05-14-2010, 01:05 PM
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
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