VBA OLE DB Query - Update SQL

[tyork]

I'm using an OLE DB Query to connect to a MS SQL Server Database to return a dataset to the workbook. I'd like to dynamically update the query and dataset by updating the SQL query with new code. I'm having a hard time finding the correct code to do this. I've done this before in prior versions of excel where i could update the command text within the connection, but it doesn't seem to work that way anymore. Any help would be greatly appreciated. The new query would be set to a string variable.