P
Peter Cooling
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
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