Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SQL Scripts in Excel
Hello, I'm using Excel 2003 and I entered 6 SQL Scripts wich are doing a
select statement to a database. All Scripts are working and the data will be shown in Excel. But if I reopen the file and refresh the data I have to enter the password 6 times to refresh all Scripts. Is there a option to insert only one times the password? Thank you. Markus |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SQL Scripts in Excel
I use a macro, recorded in Excel and MSQuery to interrogate databases. The
passwords encode themselves right in to the macro as I'm creating it. After that, I need not ever enter a password again, the macro does it for me. Perhaps the same sort of thing would work for you. hth Vaya con Dios, Chuck, CABGx3 "Markus" wrote: Hello, I'm using Excel 2003 and I entered 6 SQL Scripts wich are doing a select statement to a database. All Scripts are working and the data will be shown in Excel. But if I reopen the file and refresh the data I have to enter the password 6 times to refresh all Scripts. Is there a option to insert only one times the password? Thank you. Markus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |