Thread: CopyFolder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default CopyFolder

Your second argument should be

c:\test2\

without the wildcards.

See the help on filecopy - it is pretty clear on what is required and what
the behavior is.

Regards,
Tom Ogilvy


"Neil" wrote in message
...
I have looked at the copyfolder method, but cant seem to
get it to work, can anyone tell me the code to copy
c:\test1\*.* and all its sub folders to c:\test2\*.* ?

Many thanks in advance.

This is a good newsgroup BTW.

Neil