aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
I am wanting to place a button on a spreadsheet that has a simple query that normally user right clicks the query data and selects refresh, then it prompts for username and password (every time).
I was wondering if there was something I could put into a macro that would automatically connect them to the database that the query is refreshing its data from.
The closest thing I have found, but cannot seem to figure out how to integrate it is:
I was wondering if there was something I could put into a macro that would automatically connect them to the database that the query is refreshing its data from.
The closest thing I have found, but cannot seem to figure out how to integrate it is:
Code:
.Connection = "ODBC;DSN=XXXX ;UID=adhoc;PWD=******;SERVER=*****.server;"
