Copy Paste Files Non MS using a Macro 1

[johnbailey]

I am trying to use a macro to copy a .pdf file and then paste it to another directory. Is it possbile with the usual VBA?
Thanks
John

 

[Loomah]

Hi John
The following will do the trick no probs

Sub x()
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject&quot
fso.copyfile "\\your source path\..\pcounterorderform.pdf", "c:\"
End Sub

Copy file has a third argument which is 'Overwrite' ie overwrite the file if it already exists. The default is True, as in this case. If you change it to false and the file exists you will get a trappable error.

3 days to go
;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[johnbailey]

Loomah,

Brilliant thanks, it worked perfectly.

Cheers
John