View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lord Kelvan Lord Kelvan is offline
external usenet poster
 
Posts: 2
Default copyfile method path not found

I am getting this error and I take it is due to the destination path
does not exist is there a way to use this or another method to copy
the file and create the file path in its entirety.

Eg

SourceFile = c:/filex.doc
DestinationFile = C:/anexistingfolder/newfolder1/newfolder2/filex.doc

FSO.Copyfile SourceFile, DestinationFile