Excel 2016 OLDBConnection opening Password protected sheet
I need to know how to open a password protected Excel file using OleDBConnection. I saw a post that provides a work around.
- I am using Excel 2016. Is there a way in this version? The excel is 2013 and older.
- The work around prompts the user for the password. I don't want to prompt the user but keep it hard coded.