It worked like a charm! Many many thanks.
Turtle
turtle
Last Activity: Feb 21 '07, 07:37 PM
Joined: Feb 19 '07
Location:
-
Thanks for the quick response.
The first thing I tried was:
Dim SourceFile As String
Dim DestinationFile As String
SourceFile = "I:\ss1.xls "
DestinationFile = "A:\ss1.xls "
FileCopy (SourceFile, DestinationFile )
The error message for the last statement was "Expected =". I tried with the files dimensioned as Excel workbooks. ...Leave a comment:
-
copy an Excel workbook from one drive to another drive
This may be so elementary that no one has ever had to ask it. How do I copy an Excel workbook that is on drive E to drive F using Visual Basic 6.0? I have tried several different ways without success. I don't get error messages, it just doesn't happen.
Thanks very much,
Turtle
No activity results to display
Leave a comment: