Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
external data with a password (take 2)
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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
external data with a password (take 2)
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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Moose27713" wrote in message ... 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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
Linking to External "Password Protected" Worksheet | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
Get external data with password | Excel Programming |