Anyone have the code to open a connection and call a query in excel using vba?

thanks

and then how do i populate the parameters into different cells in exceL?