Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_open & Application.ontime in shared files
Hi,
Couple of Questions? I have a shared file whitch is saved as an HTML webpage three times a day. Sevaral users do use this file, so I had problems with the application.ontime command. I made this user specific. I solved this as follows: Sub auto_open() If fOSUserName() = "grinwisj" Then Application.OnTime TimeValue("12:30:00"), "HTMLsave" Application.OnTime TimeValue("08:30:00"), "HTMLsave" Application.OnTime TimeValue("22:30:00"), "HTMLsave" End If End Sub HTMLsave manualy started is working fine. BUT the sceduled task is not working. Questions: - How can I see if the HLMLsave is sceduled?? - Is it possible that auto_open() is not done if the other user (not the first one) is opening the sheet Jan Grinwis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.ontime from shared drive | Excel Discussion (Misc queries) | |||
Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
Shared files | Excel Worksheet Functions | |||
Application.OnTIme | Excel Programming | |||
Application.OnTime and Visual C++ | Excel Programming |