First let me say that I am not an excel expert on VB as I have been working for 2 days to create a simple VB macro / code to query an Oracle DB using the SQL query text from a worksheet cell. I tried recording a macro using pre-defined db connections but I cant find a way to use the text (dynamically created) from a cell for the actual SQL query. I think the easiest fix will be just a simple VB macro to query the DB by using the SQL text atht I am building in a cell. Any help greatly appreciated. Thanks!