Question on automating Dialogboxes in VBA

[NareshUK]

Hello, I was wondering if the following is possible in VBA. I am
running a model that pops a dialog box up once in a while - each time,
the button I click to rerun the model is exactly the same, i.e. 'Run'.
Is there anyway I can automate this process, so everytime the dialog
box pops up, it automatically clicks the 'Run' button. If not VBA, what
other program would be useful here. I was wondering if the answer might
be as simple as being able to run a Newline function within a dialog
box. Thanks.

 

[Tony Jollans]

Well, if you always reply the same to the dialog box and want to automate
it, there doesn't seem to be any point in having it displayed in the first
place. As you are asking this, I assume that you have no control over the
code that is running in this model - and that it has no options to not
display the dialog. If the model is running within Word you cannot have your
own VBA running alongside it and you may need to have a completely separate
program running within Windows to watch for it.

Can you give a bit more detail about the process(es) involved?

 

[NareshUK]

Thanks Tony. Sorry I posted my message in the wrong newsgroup. It's
actually an Excel model that I have no control over. I tried using the
Sendkeys method which works on normal dialog boxes but not on this one
unfortunately.