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.

Look at SendKeys in VBA Help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VBAQuest" wrote in message
oups.com...
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.

Is this dialog being shown by Solver?

--
Regards,
Tom Ogilvy


"VBAQuest" wrote in message
oups.com...
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.

It's not solver - it's a customised dialog box that I have no control
over. Sendkey "{ENTER}", False doesn't seem to work on it, which is a
bit of a shame. Any other suggestions?

Tom Ogilvy wrote:

Is this dialog being shown by Solver?

--
Regards,
Tom Ogilvy


"VBAQuest" wrote in message
oups.com...
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.

Problem solved. Inserted sendkeys before rather than after. Thanks very
much. Naresh