We know,Excel has prompt password
to open it files.
Is it possible to create a code that can
supplies the excel prompt password?.So that when we
open the excel file through our access control in a form,
the excel files can be opened automatically.But when the
excel files opened from its default icon,it will prompt a
password first.

On Jul 10, 8:43 pm, "shiro" <s...@play.com> wrote:
> We know,Excel has prompt password
> to open it files.
> Is it possible to create a code that can
> supplies the excel prompt password?.So that when we
> open the excel file through our access control in a form,
> the excel files can be opened automatically.But when the
> excel files opened from its default icon,it will prompt a
> password first.

check out Carl Prothman's website...

www.carlprothman.com (at least that's what it used to be...)
He has connection strings for EVERYTHING.

I've checked the site out,but not sure which one is suitable.
Can you suggest me,cause i'm not fully understand
about the string connection at all.


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Jul 10, 8:43 pm, "shiro" <s...@play.com> wrote:
> > We know,Excel has prompt password
> > to open it files.
> > Is it possible to create a code that can
> > supplies the excel prompt password?.So that when we
> > open the excel file through our access control in a form,
> > the excel files can be opened automatically.But when the
> > excel files opened from its default icon,it will prompt a
> > password first.
>
> check out Carl Prothman's website...
>
> www.carlprothman.com (at least that's what it used to be...)
> He has connection strings for EVERYTHING.
>