VBA to copy and paste folder
Just some added explanation because of Chip's response.
My method uses late binding and doesn't require the reference as Chip has
stated. His method (early binding) would be faster since creating the
reference provides more information to Excel VBA.
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
Dim fso as Object
set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFolder copy_dir, paste_dir
--
Regards,
Tom Ogilvy
"Ronaldo" wrote in message
...
Alastair,
Tried using FileSystemObject.CopyFolder copy_dir, paste_dir but gor run
time
424 error - object required - do I need to declare something??
Thanks
Ronaldo
"Alasdair Stirling" wrote:
Try the following:
FileSystemObject.CopyFolder copy_dir, paste_dir
Regards,
Alasdair Stirling
"Ronaldo" wrote:
I need help with some code to copy a folder from one destination and
paste it
to another.
Sub Transfer()
Dim copy_dir As String
Dim paste_dir As String
copy_dir = "C:\test_source"
paste_dir = "C:\test_destination"
FileCopy copy_dir, paste_dir
It seems that filecopy is not the answer, I need something like
foldercopy.
Is there a VBA command to copy and paste folders and contents similr
to
filecopy?
Thanks
Ronaldo
|