opening password protected workbook with viusal basic
Posted by n bruckerhoff on July 26, 2001 6:12 AM
I have a visual basic program that opens an excel 97 workbook and reads data from worksheets into various arrays. I need to protect the workbook so that my user cannot see the data/sheets in my workbook. After I have password protected the workbook, how can I open this workbook in my visual basic code. I'm assuming I need to pass the password, but I don't know how. If you have any advise - that would be great!