Good afternoon all. I made a simple macro the refreshes a query. My problem is that the external data source aske me for a username and password. How can I pass the user/pass in the macro so I don not have to enter in in everytime.

I have several queries that are refreshed.

Thanks in advance.

Alan