| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Using interop.excel to open a workbook, the workbook doesn't ask to save changes. | Excel Programming | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![mikeburg[_84_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
