RE: Access Query with Password
- From: "K Dales" <KDales@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 04:48:01 -0700
I have some bad news for you: you can't use ADO to open a password-protected
Excel file:
http://support.microsoft.com/default.aspx?scid=kb;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?action=getinfo&userid=18504
> View this thread: http://www.excelforum.com/showthread.php?threadid=376601
>
>
.
- References:
- Access Query with Password
- From: Dominator
- Access Query with Password
- Prev by Date: Copying data to specific columns
- Next by Date: Re: runtime error 1004 paste method of worksheet class failed
- Previous by thread: Access Query with Password
- Next by thread: Countif
- Index(es):
Relevant Pages
|
