detect file copy complete

[TomSwingruber]

How can I tell the file copy is completed?
The file being copied is an MS Acess data base.
------------------------------------
[ignore]

Public Function copy_db_to_thumb_ok() As Boolean

On Error GoTo No_copy

fso.CopyFile database_path_and_name, _
thumb_drive_letter & ":\Anyware\Mobile_Actlog.mdb"

copy_db_to_thumb_ok = True

Exit Function

No_copy:

copy_db_to_thumb_ok = False

End Function
[/ignore]

-----------------------------
Thanks much
Tom

 

[TipGiver]

Add a DoEvents() below fso.CopyFile.....
Then add something like: msgbox "File Copy Complete"


Not tested but it might be this