excel password protection

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

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.

VB Code:

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