ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File copy (https://www.excelbanter.com/excel-programming/350189-file-copy.html)

Prozor PVC sistemi d.o.o.

File copy
 
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



Gary L Brown

File copy
 
ALREADY ANSWERED IN YOUR CROSS-POST
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"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





All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com