SQL Scripts in Excel

[Guest]

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

 

[Guest]

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