Hi,
I would like to delete the existing results contained in an excel file every time I run the program. I was previously using the option "replace" but I'm not combining the excel export with a loop so I would need to delete the file before entering the loop. Any idea?
Here is what I was using before:
I would like to delete the existing results contained in an excel file every time I run the program. I was previously using the option "replace" but I'm not combining the excel export with a loop so I would need to delete the file before entering the loop. Any idea?
Here is what I was using before:
Code:
sysuse auto, clear export excel using sample.xls , firstrow(variables) replace datestring("%tq") sheet(sample_export)
Comment