password protect excel file

[komalg15]

please help with how to password protect excel file using vb6, so that it can be open for modification only via vb pogram

[Siddharth Rout]

For protecting

Osheet.Protect "Your Password"

For unprotecting

Osheet.UnProtect "Your Password"

[Hack]

Please note that anyone that knows the password can open the spreadsheet external to your program, so you might want to periodically change the password.

[komalg15]

is it possible to randomly geenerate password every time the work book closes store it in database and use it next time to open it

[Siddharth Rout]

Yes it is possible. But if the database corrupts then it will be difficult (not impossible) for you to recover the password.

MS Excel's protection has many flaws in it. It is definitely not secure. Follow what Hack suggested. Keep on changing the password manually. If possible restrict access to the workbook using Group Policies so unwanted users cannot even 'see' the file forget opening it

[Jagjit]

Hi

I have written this but it is not working

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Add()
Set xlSheet = xlBook.ActiveSheet

xlBook.SaveAs filename
xlBook.Protect [pwd]
xlBook.Close

Thanks

[dilettante]

Start a new thread.

Gravedigging ancient ones is frowned upon.

[TysonLPrice]

And if you do start a new thread something more descriptiive then "it is not working" would be helpful

Here is some free code to review that password protects:

http://www.freevbcode.com/ShowCode.asp?ID=7312