Is it possible to do this ?

[Steve]

Each day I manually do the following tasks:

i)Switch my Pc on
ii)Log on to the internet
iii)Open up an application I have on my pc
iv)Download some information from the WWW (via the
application).
v)Import the data into Access

The problem I have is that i have to be present to
undertake the various tasks.

Is there anyway that all these tasks can be automated ?
If so, can it be done in Access ? If not, can you point
me in the right direction ?

Many thanks
Steve

 

[Steve Schapel]

Steve,

I think we would need to know more about what is the application you are
using, where is the imported data coming from what is the means by which
the data is downloaded, and what the data is and what structure it is in.

 

[Steve]

Steve

I will explain it in bits (just in case we hit the first
hurdle and can go no further)

The application is a database of horseracing form. When I
open up the application (double click on the icon), I
select the Update menu option that appears at the top of
the screen. I am then taken to the update window. I
check a box within this page named "Declarations" and
press the "Update" button.

The software will establish a connection to the software
providers server and download the required information.

Is this part possible ?

Steve

 

[Steve Schapel]

Steve,

Yes, it is possible. It seems that you already have the procedures in
place within the application to do the job, it's just a matter of
setting it up so it happens via a Timer event, or triggered by a
scheduled task, rather than triggered by you clicking a button. These
procedures will be VBA routines, not macros. The only thing I am not
sure about is connecting to the internet... I mean I am sure it is
possible to automate this too, but I am personally not able to advise on
this specifically as I have never done it myself.