Thread: File copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary L Brown
 
Posts: n/a
Default File copy

ALREADY ANSWERED IN ONE OF YOUR MANY CROSS-POSTS.
--
Gary Brown

"Prozor PVC sistemi d.o.o." wrote:

Need help

drv="W" ' Map drive connection to server
src=Drv & ":\Work\Adr.xls"
dstn="C:\Work\Adr.xls"
FileCopy src,dstn

Problem is that file on server "Adr.xls" is open
When I want to copy file "Adr.xls" from server to local computer an error
ocures
File on server is always open

Is there some other command for this action

Thanks in advance

Alan