| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 closing by itself???
Hello All
I have an excel spreadsheet linked to remote sources and auto updating itself. I use it for display purposes. Production numbers mostly. Anyway it works good except for one thing. It just seems to shut itself off after about 10 or 11 hours. I haven't actually caught it happening but there's no message, or error displayed. I just find windows back at the desktop. Excel is closed. It's not in the taskbar. My code is pretty straight forward. Do, mycode, wait 2 secs, loop. I would like this display to run 24/7. I thought maybe I had a stack error but usually you get a message for that. I'm not sure what to look for. Any help would be much appreciated. I hope this all makes sense. Any ideas? Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 closing by itself???
use application.Ontime
see Chip Pearson Site http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "Paul" wrote in message ... Hello All I have an excel spreadsheet linked to remote sources and auto updating itself. I use it for display purposes. Production numbers mostly. Anyway it works good except for one thing. It just seems to shut itself off after about 10 or 11 hours. I haven't actually caught it happening but there's no message, or error displayed. I just find windows back at the desktop. Excel is closed. It's not in the taskbar. My code is pretty straight forward. Do, mycode, wait 2 secs, loop. I would like this display to run 24/7. I thought maybe I had a stack error but usually you get a message for that. I'm not sure what to look for. Any help would be much appreciated. I hope this all makes sense. Any ideas? Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 closing by itself???
Thank you Tom
Paul "Tom Ogilvy" wrote in message ... use application.Ontime see Chip Pearson Site http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "Paul" wrote in message ... Hello All I have an excel spreadsheet linked to remote sources and auto updating itself. I use it for display purposes. Production numbers mostly. Anyway it works good except for one thing. It just seems to shut itself off after about 10 or 11 hours. I haven't actually caught it happening but there's no message, or error displayed. I just find windows back at the desktop. Excel is closed. It's not in the taskbar. My code is pretty straight forward. Do, mycode, wait 2 secs, loop. I would like this display to run 24/7. I thought maybe I had a stack error but usually you get a message for that. I'm not sure what to look for. Any help would be much appreciated. I hope this all makes sense. Any ideas? Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
| Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
| Closing VB triggers closing Excel | Excel Programming | |||
| closing excel after closing a workbook | Excel Programming | |||
| Excel 2002 files attached to Outlook 2002 EMails change size | Excel Programming | |||
Linear Mode
