Posted to microsoft.public.excel.programming

external usenet poster

Posts: 23

Accept & Use ODBC Login

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Accept & Use ODBC Login	wpiet	Excel Programming	3	February 13th 09 07:09 PM
Suppressing ODBC Login Prompt	Fid[_2_]	Excel Programming	2	December 3rd 07 01:43 AM
ODBC Microsoft Access Driver Login Failed	BARRIOSWJ	Excel Worksheet Functions	0	March 6th 07 10:20 PM
Q:Excel/ODBC/Login ....	MSweetG222	Excel Discussion (Misc queries)	1	July 24th 05 06:37 PM
Q:Excel/ODBC/Login ....	MSweetG222	Excel Programming	1	July 24th 05 06:37 PM

All times are GMT +1. The time now is 12:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us