View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jutlaux jutlaux is offline
external usenet poster
 
Posts: 22
Default FileCopy Probelm

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