Hi all, I am hoping this is a simple fix.
I used some vb code to kick out data to my excel file. Basically each time the code is run, the new data overwrites the previous data on the excel sheet.
This works, it overwrites, BUT it doesn't clear out the previous information.
So say I ran it...