reading a text file(xml) which lies on a web server with VBA?

[Patrick]

Hi,

I'm very new to VBA in Outlook 2003 and I managed a macro, that reads a
xml-file and extracts data basically by parsing it.

I used the open command like this:
Open "c:/abc.xml" For Input As #1

The question now is, how do I open the xml-file if it is not stored
local but on a web server via http?

I can't open it with the "open" command.

Thx in advance,
Patrick

 

[Michael Bauer]

Am 19 Sep 2005 02:01:32 -0700 schrieb Patrick:

Patrick, the Microsoft Internet Explorer comes with the wininet.dll, which
provides you with some usefull functions.

Here´s a sample: http://www.freevbcode.com/ShowCode.ASP?ID=1252

 

[Patrick]

Thx Michael,

these functions are quite interesting.

My problem now is, that the file I want to open, lies on a https Server
where I have to enter a username/password.
Can I use those functions for this case too?
Do I have to change a constant or something like that?

Thx, in advance,
Patrick

 

[Michael Bauer]

Am 20 Sep 2005 02:05:02 -0700 schrieb Patrick:

Patrick, so far I never used that. Please google e.g. for "wininet.dll
https" in the groups and you´ll get a lot of matches.