Hi! I'm looping through hundreds of excel workbooks using a loop macro. Unfortunately, each file starts with a MsgBox (with Y/N) that says "This file is confidential, are you sure you want to continue?"
What code can I use to make it say "Yes" automatically?
I've tried:
but that didn't work (the MsgBox still popped up).
I've also tried:
but that didn't work either - MsgBox still popped up.
Please help! Thank you!!
What code can I use to make it say "Yes" automatically?
I've tried:
Code:
Application.DisplayAlerts = False
I've also tried:
Code:
SendKeys "y"
Please help! Thank you!!