Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Input box that grap data based on user answer
Hi there, I have a macro that get data from an ODBC connection and dump into a spreadsheet, the sql code get the data based on the login ID that I have to manually enter into the vba code. is there a way to create an inputbox in excel that pass this login ID as a parameter to the sql code and then get the data based on what the user enter into the input box? Code: -------------------- With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=datasource dbo.users.ID where users.login = 'userID' End With -------------------- thanks in advance for your help.. -- salooha ------------------------------------------------------------------------ salooha's Profile: http://www.excelforum.com/member.php...o&userid=14612 View this thread: http://www.excelforum.com/showthread...hreadid=507476 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Input box that grap data based on user answer
Environ("username") should give you the user's name without having to enter it. It is normally specified as USR="myname" regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=507476 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Data from another worksheet based on user input | Excel Worksheet Functions | |||
Incrementing Data based on user input | Excel Discussion (Misc queries) | |||
Copy cell data from workbook based on user input | Excel Programming | |||
Rollup of Data in Multiple Sheets (based on user input) | Excel Programming | |||
select data based on user input | Excel Programming |