But the dll doesn't have to expose the password.
It could make the connection get the data and pass
it to Excel.

RBS

"PeteCresswell" wrote in message
...
On Jul 15, 6:51 pm, "RB Smissaert"
wrote:
Put your code in a VB6 ActiveX dll.

I don't have much experience with .DLLs - maybe I've created one or
two in the distant past - but it seems like the user could still open
up an Immediate window, find the code that calls the routine in
the .DLL, execute same in the Immdiate window, and see the result.

Have I got it right?

If so, it sounds like I'm fighting Mother Nature on this one....