File not found

[rainey]

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

 

[chiello]

Wrong reference to cell B3!! (["B3"]="B3", not "E:\14Hoover\EndZone0002.avi"

Try:

Private Sub Copy_Avis()
FileCopy [B3], "C:\14Hoover\EndZone0002.avi"
End Sub

 

[rainey]

Now I have the message box:

Run-time error '52'
Bad file name or number



thanks for the help

 

[chiello]

Is the content of B3 exactly "E:\14Hoover\EndZone0002.avi"??

 

[rainey]

It is the same. One thing that is interesting is that when I highlight the contents of cell B3 by double clicking and copy then paste it works perfectly. When I just click on the cell, copy and paste there is an extra space at the end of the contents.
"E:\14Hoover\EndZone0002.avi" (a space follows the .avi" that doesn't exist if I highlight, copy and paste)
Does this matter and more important if it does, how do I fix it?

Thanks again