LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default External data and password

I have a workbook that extract data from an external SQL server from an ODBC
connection. Everytime I need to refresh the data, it is asking for a password
It is possible to VBA some code to automate the SQL server login from being
prompted every time we refresh the data

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
External Data Warning Message - I have No External Data in wrkbk Cass_makeitfun[_2_] Excel Discussion (Misc queries) 0 May 12th 10 09:02 PM
Getting External Data based on criteria insde of the external data BigMacExcel Excel Discussion (Misc queries) 0 August 31st 09 06:41 PM
How do I get external web data that requires a password? praskal Excel Programming 1 April 7th 05 11:36 AM
external data with a password (take 2) Moose27713[_2_] Excel Programming 1 November 6th 03 05:23 PM
Get external data with password Moose27713 Excel Programming 0 November 3rd 03 07:41 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"