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
Printable View
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")