Automatic open locked excel file through access control

[shiro]

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.

 

[pietlinden]

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.

 

[shiro]

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.