excel password protection

[nswan]

is it possible to bypass password protection in an excel work book by opening it through VB and looking at the values in Cells through code?

Cheers
Nick

[lintz]

You could open the spreadsheet using the required password, read the contents of a cell then close the spreadsheet again. To open the spreadsheet you can use the below.

Set oXLApp = objExcel.Workbooks.Open(FileName:=App.Path & "\" & "Book1.xls", Password:="MyPassword")