Erase Data on Exit

[WorkinOnIt13]

I use a program that runs CASL Macros. And the macros are setup to retrieve certain data, and then open a specific Excel file, and paste the data there. However upon exiting the Excel file, If I re-open that file the data is still there.

Is there a VB code I can write that will erase anything on that file upon exiting???

 

[Smitty]

Something like this maybe:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Sheets("Sheet1").Cells.ClearContents
End Sub

Or do you need to delete data on all sheets as well?

HTH,

Smitty

 

[WorkinOnIt13]

Nope just the one sheet will work. Thanks man!