Closing MessageBoxes not using DisplayAlert

[samuelgvega]

Hello,

On a regular basis we have to run some sheets manually, copying and pasting the parameters to run the formulae. I am trying to automate it, but I have no access to the code behind the sheet, so I have come around this issue using SendKeys to virtually click on the buttons for me (I don't it isn't very elegant but I can't call the procedures directly through my code).

Unfortunately, one of the procedures launches an OK/Cancel warning box about data being modified. My problem is that I can't find a way to either get ride of the window or "click" on the OK for carrying on. I have tried to false DisplayAlerts but it doesn't work with this window because I guess it's part of the code I can't access.

Any idea?

 

[SkipVought]

hi,

but I have no access to the code behind the sheet

WHY?

copying and pasting the parameters to run the formulae

Could you be more specific? This does not sound like best and accepted proctices.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]