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

  • Thread starter Thread starter Patrick
  • Start date Start date
P

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
 
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
 
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.
 
Back
Top