Set up a time to kick off the command button click event.

[AuctionLamb]

Hi guys!!!

Need some help with this issue I have. I have an application that builds up XML files and save it in a folder on the server. The application ONLY has one button that I click to get the data, to build the XML, to save it to the server for that day it has been clicked.

How can I make this button to be "clicked" automatically without someone having to go and click it everyday?

THANKS!!

 

[HarleyQuinn]

Use a Timer control or get your program to run as a Scheduled Task in Windows.

Harleyquinn

---------------------------------
For tsunami relief donations

 

[TimBiesiek]

I would use a timer set for every 10 minutes (for example), and then check the hour of the current time, then if the hour is the hour you wish to run the button on, execute the procedure to run your code... The timer could be changed to every minute if you wanted to be quite precise about the time you run it...

E.g. Something like this:

Sub TmrTimeCheck

if left(time,1) = 23 '(11pm on 24 hour clock) then
Call ButProcess_Click
End if

End Sub

Public Sub ButProcess_Click

'Do required processes behind button click

End Sub