Automatic open locked excel file through access control

  • Thread starter Thread starter shiro
  • Start date Start date
S

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.
 
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.
Click to expand...

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
Excel Protection 2
Excel opening 1
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Record-Locking remains open after closing 0
Open .xlsx files in Excel 2002 2
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0
Issues when opening excel through access 10

Back
Top