Problem not wanting to open a file with modify file password...

Hi

I have created a loop that opens all the Excel files in a directory, in order to make modifications to the ones that don't have passwords attached. I've been able to identify files with passwords when opening them and I am able to ignore them. However I have a problem with files with a 'modify file' password as the modify file dialog box appears. Is there anything I can do to use VBA to stop this dialog appearing as send keys don't seem to work (as you have to press Cancel on the dialog box first which defeats the purpose).

Many thanks

James

Application.DisplayAlerts = False - Could try that? Not sure if it would cause other problems for you though if you're using sendkeys on other parts of your code.

Unfortunately already have that in my code

I'm a little confused what you mean by a "modify file password" - can you explain that a bit more? Are you talking about a sheet protection password, workbook protection password, windows secured password, etc?

When you save an Excel file, under Options you can either password to open a file (to stop an unwanted user from opening a file) and/or password to modify a file (which allows a user to open a file but not save changes unless they have the password).

Hope this helps

James