PDA

View Full Version : How to call (silently) an URL with VBA ?



Origami
06-17-2010, 02:03 AM
Hello all, :hi:

I'm currently writing a VBA macro for Outlook, and I'm extracting the IP addresses from the email headers.
I would like to get the geographical locations of the IP addresses from an internet site automatically.

So, I would like to be able to retrieve in VBA the HTML page generated by the internet site, to then process it and extract the country, state and city. All this without opening a brower at the face of the user.
So, I need to be able to call an URL and then get the result HTLM code on the background.
Is it possible ?

Thanks a lot or your help. :thumb

Crocus Crow
06-19-2010, 11:47 AM
You could use IE automation and set the Visible property to False, or use XMLHTTP.