Copying folder & contents(XL97VBA)

[davidtrickett]

Does any one have a routine for copying a folder and its contents, including subfolders & their contents, from one place (i.e. drive) to another?

I imagine that this will require clever use of the DIR function, but my poor little brain can't quite get round it!

Thanks

[Q]

Do you want to do this from within a spreadsheet or do you want to do this while the workbook is closed?

[ This Message was edited by: Q on 2002-05-22 06:00 ]

[davidtrickett]

Thanks Q

I want to do this with a VBA routine in a workbook. If vba had this function it would go something like this:

Sub copymyfolder
CopyFolder "C:myfolder","D:myfolder",SubFolders:=True
End sub

[davidtrickett]

Q
Re my last - somehow double backslashes got into the paths!