I have VBA cose that inserts SQL into microsoft query and then is supposed to refresh the query. The code runs fine without any errors and inserts the SQL into ms Query. once the code has finished if i look at the query it does not return any rows of data but then if i go into msQuery and exit and return data to ms excel it runs the query fine.
im not sure if thats a good explanation but if anyone can help it would be greatly appreciated.
Thanks