How to set an Alarm in the attached ??
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
To set an alarm you can use the Ontime method, but the workbook would need to be open
Last edited by royUK; 11-26-2010 at 04:38 AM.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Re: How to set an Alarm in the attached ??
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
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.
Last edited by protonLeah; 11-26-2010 at 02:42 PM.
---
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks