Hi, i am a silver member on the Ytube, how do i get into the member forums? Do i need to be gold? Question, i did an online search and you dont have a video about Access QueryDefs. I am trying to use your technique to output my data to an excel sheet in one click. But, my query only exist in vba in a variable, as its dynamic, parts of it need to change. The output to command wont except the name of the variable so i need to save as a queryDef? Any help wpuld be appreciated. Happy Easter to all. Ps you got me to with the clippy video!!!