| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sql server password entry during macro run
i have an excel worksheet which is a straight link from an access query, this
works fine but when i come to refresh my data in the excel sheet i get asked for the "sql server Login password" my user name is there by default and i would like to insert the password automatically as im running a macro to automatically refresh the data. is there some code to insert this password automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I protect all excel tabs in a file with one password entry? | Excel Discussion (Misc queries) | |||
| password protecting a column for data entry in a sheet, how? | Excel Worksheet Functions | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Linear Mode
