Accept & Use ODBC Login

wpiet

Guest

Posts: n/a

13th Feb 2009

In a workbook with multiple sheets, each with an associated DB query, how can
I have a user enter ODBC login username & password just once, then use these
to automate each subsequent login as the macro loops thru the sheets,
refreshing data in each.
--
Will

« odd issue with a loop | Early bind to Late bind »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Accept & Use ODBC Login	wpiet	Microsoft Excel Programming	3	13th Feb 2009 07:09 PM
Accept username & password once; Use for multiple ODBC logins	wpiet	Microsoft Excel Programming	0	13th Feb 2009 06:57 PM
Windows Mail won't accept my login and password	Dustin Harper	Windows Vista Mail	5	1st Jan 2008 02:12 AM
Outlook won't accept my login/password information.	=?Utf-8?B?U3dheXplbmU=?=	Microsoft Outlook Installation	0	22nd Oct 2006 05:13 AM
Wont accept password at login		Microsoft Windows 2000 Security	0	31st Oct 2003 11:23 AM