I'm trying to write a program that uses web services (XML) with a
login/password to populate a custom userform that collects more data through
web services and plops it all in a single report. I want different filters
to be available to users so they can see products based on manufacturer or
other specifications. There are dozens/hundreds of products per
manufacturer. I don't even know if what I want to do is possible so I would
appreciate any feedback/direction.

I want to be able to query (in a sense) the web services to populate a
listbox from which the user will select different products he/she wants to
examine (moves to another listbox). I then want to use that list from the
second listbox to query the webservices and get more information about the
products (price, discounts, etc.).

My alternative is doing a raw data-dump that takes more than 5min and
creates a big-ass file (10MB+) neither of which I am very fond of. Again, I
don't know if I'm asking too much. I appreciate any help, tips, pointers,
laughs in the face, etc. :)

--
-SA