external data with a password (take 2)

[Moose27713]

This is my second time submitting this question. I did not receie any
responses the first time.

I want to get external data with and pass a password but the password
can not be displayed at any time.

I have set it up so the user ID and various paramaters are sucessfully
passed in my external call by establishing the cell reference while
building the call.

However, when I have a variable on a form so I can protect the
password, I don't know how to reference the varable in the external
call.

Thanks in advance.

MPH

 

[Dick Kusleika]

MPH

I don't understand the question. Where are you collecting the password? On
a userform? Won't it be displayed there? Is that what you are trying to
avoid?

Generally, the password is in the connection string of the external data
table (QueryTable object). When you add the QueryTable and supply the
connection string, put your variable in the string. I believe it goes after
the DBQ entry, but record a macro while you do it manually and see where the
PWD entry is.

Post back if that's way off the mark.