In Cell B3 I have the following cell reference:
"E:\14Hoover\EndZone0002.avi"
When I run the following code:
Private Sub Copy_Avis()
FileCopy ["B3"], "C:\14Hoover\EndZone0002.avi"
End Sub
I get following message box:
Run-time error '53'
File Not Found
I have doubled checked and the file exists.
As a matter of fact to make sure the file exists when I run:
Private Sub Copy_Avis()
FileCopy "E:\14Hoover\EndZone0002.avi", "C:\14Hoover\EndZone0002.avi"
End Sub
It works like a charm.
I have been working on this for weeks with no resolution. Any help would be appreciated.
Thanks
"E:\14Hoover\EndZone0002.avi"
When I run the following code:
Private Sub Copy_Avis()
FileCopy ["B3"], "C:\14Hoover\EndZone0002.avi"
End Sub
I get following message box:
Run-time error '53'
File Not Found
I have doubled checked and the file exists.
As a matter of fact to make sure the file exists when I run:
Private Sub Copy_Avis()
FileCopy "E:\14Hoover\EndZone0002.avi", "C:\14Hoover\EndZone0002.avi"
End Sub
It works like a charm.
I have been working on this for weeks with no resolution. Any help would be appreciated.
Thanks