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