Re: Linking to excel spread*** over the Internet

From: Matthew Freeze (Matthew.Freeze_at_mctg.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 16:49:01 -0400

Mr.Wijnker:
Thank you very much, Iwill give it a try and let you know if it works, or
what I did to solve this problem. --Matt
"Sietse Wijnker" <sietse.wijnker@ATsw-software.nl> wrote in message
news:OV$5wMQnEHA.3172@TK2MSFTNGP10.phx.gbl...
> Hi Matthew,
>
> To download a file from the internet you can use the following:
> DECLARE INTEGER URLDownloadToFile ;
> IN urlmon.dll ;
> INTEGER pCaller, ;
> STRING szURL, ;
> STRING szFileName,;
> INTEGER dwReserved, ;
> INTEGER lpfnCB
>
> = URLDownloadToFile (0, lcURL, lcLocalFile, 0, 0)
> The problem here is that there's no way of knowing the file size and date
> before downloading it. To retrieve that kind of information you can place
an
> XML file next to it specifying the file size and date, and retrieve the
XML
> file in the same way, or you can use the XMLHTTP object like this:
>
> objHTTP = CreateObject("MSXML2.XMLHTTP")
> objHTTP.Open("GET", url,.f.)
> objHTTP.Send()
>
> After a successfull dwnload the objHTTP.responsexml cotains the XML that
is
> retrieved in a DOM
>
> Maybe there's a better way for etrieving file info before you download,
but
> i'm still searching for it
>
> Regards,
> Sietse Wijnker
>
>

Loading