Question Access protected Microsoft Office file directly

[sorin2003]

Is there any possibility to access directly from a Windows form created in VB.net a protected Excel file? I mean, that the password for opening xls file to be stored in VB.net Windows form.
I also have the same problem for a Microsoft Access protected file.
Tks for your time!

 

[jmcilhinney]

Absolutely. You probably won't want to hard-code it but you can store it in the application settings or some other file. You might also want to think about encryption if you don't want everyone to be able to see it.

 

[sorin2003]

Do you have any suggestion of code write in VB.net to resolve this problem! I tried some codes but none of them work! Thanks