copy an Excel workbook from one drive to another drive

[turtle]

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

[Killer42]

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.

If you just need to copy the XLS file, try the FileCopy statement.

[turtle]

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. I also tried several variations with an equal sign inserted in the last statement.


I also tried:

My.Computer.FileSystem.CopyFile("I:\ss1.xls","A:\" )

The error message again was "Expected =".

I am working in Visual Studio 6.0. Somehow I am not doing something right.

Again, thanks.

Turtle

[Killer42]

It's not the specific statements that are giving you trouble here, it's your general syntax. You only use parentheses like that when retrieving a value from a function, or specifying an element in an array. For example, this slight variation on your original code should work better...

Dim SourceFile As String
Dim DestinationFile As String
SourceFile = "I:\ss1.xls"
DestinationFile = "A:\ss1.xls"
 FileCopy SourceFile, DestinationFile

(Also, note that it's a bit more readable if you place CODE tags around it when posting here, as I have done.)

[turtle]

It worked like a charm! Many many thanks.

Turtle