How to set an Alarm in the attached ??

**beautify5** · 11-24-2010, 03:27 AM

Hello Smart Friends,

Brief overview of my need:
We maintain a time tracker for time spent on each activity and at the end of the day the time collected in spread sheet needs to be entered in SAP Website.

Can you please help me with below :
I already have time tracker attached wit this post

Help 1 : I want to trigger an Alarm at 10:30 PM everyday on the same file as a reminder to enter spreadsheet time collected on a whole day to SAP Website.

Help 2 : I want to set a tab in the below blank space wherein I click and it takes to my SAP Website.

Thanks in advance...

Charmi

**royUK** · 11-24-2010, 04:16 AM

To set an alarm you can use the Ontime method, but the workbook would need to be open

**beautify5** · 11-24-2010, 05:07 AM

Thank you so much for your response. I am very new to this. I dont know what is ontime

Can you edit the attached file and do it for me please. or else give me the code for that.. This will help a lot.

Thanks a lot again, Appreciate a lot.

Charmi

**protonLeah** · 11-26-2010, 03:39 PM

Can you edit the attached file and do it for me please

Please, at least, try to figure it out on your own. See:
---
http://www.ozgrid.com/Excel/run-macro-on-time.htm
---
If you can not get it to work, then post the actual code you wrote.