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.

  1. I am using Excel 2016. Is there a way in this version? The excel is 2013 and older.
  2. The work around prompts the user for the password. I don't want to prompt the user but keep it hard coded.

0 answers