query database in excel vba code with user input?

[xq]

i am writting sql in text file then read it as string , pass it to query database in sql server, but i need user input date to query, is there another way instead of reading sql as string(cos i'm not able to place the user input date in the middle of sql string), is it possible to set a variable, assign user input date value to that variable, then i put that variable in the sql, then query it? something like transact sql? any help is appreciated!