There are a number of methods you could use in order to fetch the xmlfile
Eg.

API call
XMLHttp object

Lots of examples on both via google

Eg:

Function GetContent(sURL As String) As String
Dim oXHTTP As New MSXML2.XMLHTTP

oXHTTP.Open "GET", sURL, False
oXHTTP.send
GetContent = oXHTTP.responseXML
End Function


Tim


"anjanesh" wrote in
message ...

Fountainhead - Im actually looking for a macro and not using VB .NET and
embedding the xls into it. I thought the framework alone would do make
NET macros !
Tim - the dropdown will be taken from a remote xml file which I shall
parse and display. This xml file changes over time - that why I wanted
to have this macro connect to the net.


--
anjanesh

Freelance Developer
------------------------------------------------------------------------
anjanesh's Profile:
http://www.excelforum.com/member.php...o&userid=27132
View this thread: http://www.excelforum.com/showthread...hreadid=526272