By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,058 Members | 1,336 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,058 IT Pros & Developers. It's quick & easy.

vb program to unlock excel workbook

P: 30
hi

can i get help for a line of vb program which unlocks the excel file and reads the data into the text boxes of vb.

I did a small program which reads data from excel file into text boxes of vb form. i wanna set password for excel workbook file so that it should be opened only through vb login form using that password.

the following which i tried is not working:

Option Explicit
Public ExlObj As Excel.Application
-----------------------

ExlObj.activeworkbook.unprotect ("xyz")
Dec 30 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.