View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fountainhead[_3_] Fountainhead[_3_] is offline
external usenet poster
 
Posts: 1
Default Filling dropdown values from remote xml file


anjanesh Wrote:
Hi

I need to make one cell a drop down. This drop down will be filled with
values that is to be retrieved from the net as an XML file. I can figure
out how to parse the XML because there are enough functions to do that
using .NET but how do I get the url content in the macro ?
Also, is .NET supported in macros ? It would be a lot easier if it is.

Thanks


Have you considered creating a reference to Excel in your project then
making the calls directly from .Net?


--
Fountainhead
------------------------------------------------------------------------
Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825
View this thread: http://www.excelforum.com/showthread...hreadid=526272