Need VBA code to save column J of open workbook called
LmbcAcctsPayable.xls, Sheet1, to same workbook & sheet called
LmbcAcctsPayable.xls, Sheet1, when save is not selected.

Reason: The workbook is usually not saved because it is more of a
templet with names in column A. Column J is updated with a date when a
row is used so I need the column J to copy automatically to the blank
templet when exiting without saving (using ThisWorkbook.Save = True in
Auto_Close). That way, rows not being used for a long period of time
can be periodically eleminated.

Thanks so very much. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=546059