ExcelBanter - Copy from CD

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

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

- - Copy from CD (https://www.excelbanter.com/excel-programming/326511-copy-cd.html)

Roger

Copy from CD

please give example of code to copy a file called Update.xls from my CD "D
drive" to C:\Dar\
--
Roger

Bob Phillips[_6_]

Copy from CD

Dim SourceFile, DestinationFile
SourceFile = "D:\myFile.xls" ' Define source file name.
DestinationFile = "D:\Dar\myFile.xls" ' Define target file name.
FileCopy SourceFile, DestinationFile ' Copy source to target.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Roger" wrote in message
...
please give example of code to copy a file called Update.xls from my CD "D
drive" to C:\Dar\
--
Roger

All times are GMT +1. The time now is 07:00 PM.