Question about "TransferSpreadsheet" action

[Mary]

Would like to export data to an excel file by the TransferSpreadsheet action
and found that data are appended to the original excel file.

I wonder if any methods to replace the original file or delete the old file
before data transfer.

My interim solution is to ask user to delete the old file by himself before
running the macro.

Thanks a lot!

 

[Ken Snell \(MVP\)]

Using VBA code, you can delete the file before you run the
TransferSpreaddsheet action:

Kill "PathToFile\FileName.xls"

 

[Mary]

it work. thanks!

Using VBA code, you can delete the file before you run the
TransferSpreaddsheet action:

Kill "PathToFile\FileName.xls"

 

[EeOr]

It may also be useful to put a check in to ensure that the file hasn't
already been deleted (or you would probably get an error):

If Dir("PathToFile\FileName.xls") = "" Then
Else
Kill "PathToFile\FileName.xls"
End If

Jon

 

[Mary]

thanks a lot! already added.

It may also be useful to put a check in to ensure that the file hasn't
already been deleted (or you would probably get an error):

If Dir("PathToFile\FileName.xls") = "" Then
Else
Kill "PathToFile\FileName.xls"
End If

Jon