Question on automating Dialogboxes in VBA

  • Thread starter Thread starter VBAQuest
  • Start date Start date
V

VBAQuest

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)
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get Find dialogbox through VBA macro in Excel2007 11
Open DialogBox in VBA 5
Multipage dialogbox 2
Excel 2003 Add-In Automation 2
Automating key strokes to a dialog box 2
VBA in IE window 1
Excel VBA in Citrix. 0
Change Save Dir in IE (VBA) 4

Back
Top