MsgBox - "Yes"

[lilanngel]

Hi All,

Using a loop macro, I am going over hundreds of files. However, each file starts with a MsgBox that says "This file is confidential, are you sure you want to continue?"

What code can I use to make it say "Yes"?

I've tried:

Application.DisplayAlerts = False

but that didn't work (the MsgBox still popped up).

I've also tried:

SendKeys "y"

but that didn't work either.

Please help! Thank you!

[Andy Pope]

Assuming the workbooks have code using the Workbook_Open event and that by not running this event the information in the workbook is still usable then try this approach.

Book1.xlsm contains the following event code.

Please Login or Register  to view this content.

This code in another workbook will open the file without the message box appearing, then close it.

Please Login or Register  to view this content.