TransferSpreadsheet

[Chris]

I'm using the TransferSpreadsheet function in a macro, which I have done
numerous times, but instead of overwriting the existing spreadsheet each
time it is ran it appends to it. Any suggestions as to why this problem is
happening? I've never experienced this before.



Thanks,

Chris

 

[bob]

The best workaround for this is to use VBA and KILL to delete the file first

If VBA is not your thing, create a batch file that deletes the file and run
the batch file from a macro.

Bob Galway

 

[Chris]

Thanks bob. Would it be possible for you to give me an example of creating
the batch file and where in the macro I add it? I've never done this
before.

Thanks,
Chris