I have a spreadsheet with query to an ODBC data source

Each time the spreadsheet is opened and query refreshed it prompts for the
USERNAME an PASSWORD which in this instance are both blank.
Is there a way to pass the logon credentials in a macro? or other way of
avoiding the prompts?

Thanks


--
Thanks