Save column J of WorkBook when WorkBook is not saved.
 

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

Save column J of WorkBook when WorkBook is not saved.
 

The only way to save a given range is to copy that range to anothe
workbook then save that workbook

--
bgeie
-----------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...fo&userid=1282
View this thread: http://www.excelforum.com/showthread.php?threadid=54605

Save column J of WorkBook when WorkBook is not saved.
 

That's the only way I could find too! Thanks a million. mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=54605