Hi!

I'm using a COM Add-in in Excel 2002 to invoke a web-service on a
remote IIS-server.
There will be cases when I can't use windows integrated security for
this, due to cross-domain requests, etc. Therefore, I need to turn to
basic authentication. In other words, the user will somehow provide the
username/password manually.

My problem is that I don't like the idea of writing custom code to
collect user's credentials - it feels a little unsecure. Not only that,
some of my customers would probably hesitate from using the add-in when
their IT-pros hear about this...

So, is there anyway around the problem? Can I tell Excel to show a UI
that collects the credentials (I know Excel pops-up a dialog when using
web-queries over basic auth)? Or can I "borrow" the credentials from
IE, Excel or even Windows?

Any advice appreciated!
/Fredrik