Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save workbook on time
ThisWorkbook.save I have above code to save workbook every half an hour, which works fine.. But even when I open this file and close it, still every half an hour it opens on its own and saves. How to overcome this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
save workbook on time
Tell excel to stop the timed macro when the workbook closes. Take a look at Chip Pearson's notes: http://www.cpearson.com/excel/OnTime.aspx You'll see how he uses a variable to hold the next start time and how he uses that to stop the timer. Kash wrote: ThisWorkbook.save I have above code to save workbook every half an hour, which works fine.. But even when I open this file and close it, still every half an hour it opens on its own and saves. How to overcome this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Save Time for non active shared workbook | Excel Programming | |||
Time to save a workbook | Excel Programming | |||
Save Workbook as Current Date/Time | Excel Discussion (Misc queries) | |||
adding before save so it works every time excel opens and with any workbook | Excel Programming | |||
auto save on exit while at the same time rename workbook... | Excel Programming |