Previous Thread:   Import to custom contacts form

9/19/2005 2:01:32 AM    reading a text file(xml) which lies on a web server with VBA?
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



9/20/2005 2:05:02 AM    Re: reading a text file(xml) which lies on a web server with VBA?
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

9/20/2005 8:09:25 AM    Re: reading a text file(xml) which lies on a web server with VBA?
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  
  
--  
  
Viele Gruesse / Best regards  
  
Michael Bauer - MVP Outlook

9/21/2005 7:51:00 AM    Re: reading a text file(xml) which lies on a web server with VBA?
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.  
  
--  
  
Viele Gruesse / Best regards  
  
Michael Bauer - MVP Outlook