Check if file is password protected

[absarshah]

Hi everyone! I'm looking for a way to check if an Excel file is password protected. If so, VBA should open it with the "default" office password. This should happen anytime a file is opened by any means (i.e. from Windows Explorer, and not just through another piece of code in another Excel)

I tried using CExcelEvents to monitor when a file is opened, and then execute a specific code when a file is opened. Unfortunately, this event is only triggered once the password has already been entered and the file is open. I would like to trigger code BEFORE the file is actually opened, so that I could then use the Workbook.Open method to open the file with a specific password.

Any help appreciated!

 

[Jaafar Tribak]

Why can't the user insert the password manually to open the protected excel file(s)?

The only workaround I can think of is to have an excel file in a hidden excel instance which is loaded whenever the computer is switched on .

This hidden excel file will have code to monitor when a password protected excel file is being opened either via code or from the UI.

The code in the hidden file will set up a system wide shell hook that will detect the password prompt dialogbox when it comes up and will automatically send to it the required password as click the ok button.

Not easy but I think should work .

 

[absarshah]

Why can't the user insert the password manually to open the protected excel file(s)?

The only workaround I can think of is to have an excel file in a hidden excel instance which is loaded whenever the computer is switched on .

This hidden excel file will have code to monitor when a password protected excel file is being opened either via code or from the UI.

It's an efficiency matter. Due to confidentiality reasons, any file which leaves the company server (e.g. over email) must be encrypted with a password. Which means that basically all of our documentation is encrypted. This of course gets very tiresome

 

[Jaafar Tribak]

@absarshah

Which version\Edition of excel do you use ?

Edit:

And are the files just password protected but have full write access to them ?

And is the password the same for all files ?