I have a query on a database that i want a macro to re-fresh it. Unfortunately when i run the macro for the first time while the spreadsheet is open it comes up with the SQL serve Login box.

I know the login for the SQL server, so is there anyway i can put this into the macro?