Hi,
I have developed an Access application that is linked to an Excel
spreadsheet. The spreadsheet is regularly updated and new updates are
available on a HTTP server. Is there an easy way of regularly checking for
updates and downloading the file to my Access application working directory?
Thanks
S

Take a look at the following

http://forums.devx.com/showthread.php?threadid=163915
http://vbnet.mvps.org/index.html?cod...loadcustom.htm

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Sacapuce" wrote:

> Hi,
> I have developed an Access application that is linked to an Excel
> spreadsheet. The spreadsheet is regularly updated and new updates are
> available on a HTTP server. Is there an easy way of regularly checking for
> updates and downloading the file to my Access application working directory?
> Thanks
> S

Superb, thanks you very much Daniel, much appreciated.

For reference, I also found the following which involves using a dll :
http://www.mvps.org/access/modules/mdl0037.htm
http://www.pcreview.co.uk/forums/thread-1635020.php

Sacapuce

"Daniel Pineault" wrote:

> Take a look at the following
>
> http://forums.devx.com/showthread.php?threadid=163915
> http://vbnet.mvps.org/index.html?cod...loadcustom.htm
>
> --
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "Sacapuce" wrote:
>
> > Hi,
> > I have developed an Access application that is linked to an Excel
> > spreadsheet. The spreadsheet is regularly updated and new updates are
> > available on a HTTP server. Is there an easy way of regularly checking for
> > updates and downloading the file to my Access application working directory?
> > Thanks
> > S