ExcelBanter - Copying files in VB

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copying files in VB (https://www.excelbanter.com/excel-programming/311797-copying-files-vbulletin.html)

Reney R. Langlois

Copying files in VB

Hi,
Is there a way around the FileCopy command for copying
an Excel file which is open at another computer to my
local one?

Thanks much,

jaf

Copying files in VB

Hi Reney,
See SaveCopyAs in VBA help.

--

John
johnf202 at hotmail dot com

"Reney R. Langlois" wrote in message
...
Hi,
Is there a way around the FileCopy command for copying
an Excel file which is open at another computer to my
local one?

Thanks much,

All times are GMT +1. The time now is 02:45 AM.