Firing off an event

I have a backup program I wrote with VB and need help on how to set it off on Sunday's at 6:00 pm.  I thought about the timer but don't see how the timer will trap the 6:00 pm.  Any help you could give would be appreciated.
Thank you.
HushAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jaysin28Commented:
the timer wouldn't help anyway unless the computer running your program

1 - Stayed on 24 hours a day, 7 days a week
2 - Your program was never shutdown.

I would think about setting task scheduler to run your program on Sunday's at 6:00pm or your program will need to be a Terminant-Stay Resident program.
0
BeedleGuisCommented:
the simplist way would be to use a timer set to go every minute then just do
If format(now, "dddd") = "Sunday" and format(now,"Hh:Nn:Ss") >= 6:00:00 and format(now,"Hh:Nn:Ss") <= 6:00:59 then

'Backup
End if
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jaysin28Commented:
BeedleGuis,

Your answer would work assuming the conditions that I have outlined in my comment have been met.

0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

BeedleGuisCommented:
Jaysin is right . . If your not going to leave your program running all the time.  If you are running 24/7 then my code should fire once every Sunday at 6:00.  Oops  change those 6's to 18's, otherwise it'll go in the morning, Also make sure the timer interval is set to 60000, or it might miss it, or it might run it twice.
0
BeedleGuisCommented:
Jaysin . .one of these times our comments are going to collide and down the server .. :-)
0
Jaysin28Commented:
I know.... I have answered a few questions yesterday and before my screen updated, you had submitted an answer.  

i.e.  The coment on the question about Object Type.

Jaysin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.