FileCopy

[Bill]

Does the execution of code following the use
of VBA function FileCopy automatically wait
until the copy completes? If not, what methods
are available, like a ShellWait, so that one can
verify a successful copy before proceeding.

Thanks,
Bill

 

[Marshall Barton]

Does the execution of code following the use
of VBA function FileCopy automatically wait
until the copy completes? If not, what methods
are available, like a ShellWait, so that one can
verify a successful copy before proceeding.

I'm pretty sure that the FileCopy statement is synchronous,
but test it by copying a huge file immediately followed by
the FileLen function to see if the copy is full size.

 

[Bill]

Hi Marsh,
Good idea. I have plenty of large WAV files and
will configure a test later this evening..........stay
tuned.
Thanks,
Bill

 

[Bill]

The FileCopy statement is synchronous indeed.
I copied a 666MB wav file and awaited the
report via MsgBox, and the length of the
new copy is equal to that of the source file
after about 20 seconds or so for the copy to
complete.

Thanks,
Bill