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