msquery prompt for password

[jocke]

hi, is it possible to use the shell command to send a password to msquery when msquery prompts for password when updating query.

i usually open databases with ado but in this case i cannot do so.
And i'd like to refresh the query automatically when file opens.

[Ardus Petus]

Edit the "connection" property of your Querytable, and add
";password=whatever"

HTH
--
AP

"jocke" <jocke.24ts5m_1142618101.0961@excelforum-nospam.com> a écrit dans le
message de news:jocke.24ts5m_1142618101.0961@excelforum-nospam.com...
>
> hi, is it possible to use the shell command to send a password to
> msquery when msquery prompts for password when updating query.
>
> i usually open databases with ado but in this case i cannot do so.
> And i'd like to refresh the query automatically when file opens.
>
>
> --
> jocke
> ------------------------------------------------------------------------
> jocke's Profile:
http://www.excelforum.com/member.php...nfo&userid=766
> View this thread: http://www.excelforum.com/showthread...hreadid=523663
>

[jocke]

i don't create the query in vba i have it in a worksheet.
how can i edit the connection property then?


this is my code

With ActiveSheet.QueryTables("testdata")
.Refresh BackgroundQuery:=False
End With

/jocke

[jbrackett]

Right-click somewhere in your dataset > Data Range Properties... > Save password...

Another one I check is to "Fill down formulas in adjacent columns..." at the bottom of the dialog box. This is great for grouping or conditioning data for use in pivot tables. (Example: a date cell to a month or day of week or using a nested if to return values)

Regards,

Jay