Perfrect. I figured that since the file didn't exist in the first place it
would not matter, but I was wrong. Thanks for the help.

"Allllen" wrote:

In the source you specified the source filename. So in the destination you
need to specify the new filename. You can't just overwrite the C:\.

try
strFileDestination = "C:\OT.xls"

--
Allllen


"jutlaux" wrote:

I am trying to copy a file from a network location to a local drive via the
below code, but ever time I go to run the macro I get a "Path not found
error" what am I doing wrong?
sub CopyOTFile
strFileSource = "N:\shared\ENGINEER\ELECTRIC\OT.xls"
strFileDestination = "C:\"

FileCopy strFileSource, strFileDestination
end sub