Access Query with Password
 

I have seen a few posts on how to use VBA in Excel to get information in
a query. My problem is that I cannot find how to get it "save the
password" so that a password popup does not appear.

I am planning on using the "Sub sCopyRSExample()" that copies the
information into an existing sheet as seen on this site:
http://www.mvps.org/access/modules/mdl0035.htm

Any help would be greatly appreciated.


--
Dominator
------------------------------------------------------------------------
Dominator's Profile: http://www.excelforum.com/member.php...o&userid=18504
View this thread: http://www.excelforum.com/showthread...hreadid=376601

Access Query with Password
 

I have some bad news for you: you can't use ADO to open a password-protected
Excel file:
http://support.microsoft.com/default...b;EN-US;211378
However, there is a workaround: it is possible to use ADO if you first open
the workbook. So you could open it (hidden if necessary) in your code first
- see Method 2 in the reference above.

"Dominator" wrote:


I have seen a few posts on how to use VBA in Excel to get information in
a query. My problem is that I cannot find how to get it "save the
password" so that a password popup does not appear.

I am planning on using the "Sub sCopyRSExample()" that copies the
information into an existing sheet as seen on this site:
http://www.mvps.org/access/modules/mdl0035.htm

Any help would be greatly appreciated.


--
Dominator
------------------------------------------------------------------------
Dominator's Profile: http://www.excelforum.com/member.php...o&userid=18504
View this thread: http://www.excelforum.com/showthread...hreadid=376601