Clicking a single button in webbrowser 1

[shavenlunatic]

Hi,

I have embedded a "Webbrowser" in a word document. I want to perform the simplest of tasks.

on whatever action, I would like it to activate the browser, navigate to a given page and then click on a button (which I know the name of)

simple as that, no numbers to fill in, no values to send. I don't care if it's quick and dirty (other than sendkeys) but I'd just like to have it perform that action


viewing source of the page

<input type='submit' name='refreshthis' value='REFRESH'>

and the code so far, I have a feeling I should really be creating this as an object etc.. but this just seemed quicker and simpler for the task at hand

Webbrowser1.Activate
Webbrowser1.Silent = True
Webbrowser1.Navigate("[URL unfurl="true"]http://www.thesite.com/index.php?on=rejig")[/URL]

Thanks in advance

________
clueless

 

[shavenlunatic]

or - found this somewhere, I just can't figure out how to "click" the button...

  Dim IE As Object
  Set IE = CreateObject("InternetExplorer.Application")
  IE.Navigate "[URL unfurl="true"]http://www.thesite.com/index.php?on=rejig"[/URL]
  IE.Visible = False
  While IE.Busy
    DoEvents
  Wend
  'IE.Document.All.SOMETHING?????

________
clueless

 

[misterstick]

why do you need to click the button?
simply perform the "navigate" call that the button does.
i'm guessing it's in the it's in the html form declaration looking something like [tt]<form method=POST action=index.php>[/tt] where action is the url the results are posted to.
good luck.



mr s. <

 

[shavenlunatic]

ah, it's ok. Finally managed to figure it out with some experimentation, i guess I'll post the info in case of the unlikely event of someone wanting to do the same thing.

  Dim IE As Object
  Set IE = CreateObject("InternetExplorer.Application")
  IE.Navigate "[URL unfurl="true"]http://www.thesite.com/index.php?on=rejig"[/URL]
  IE.Visible = False
  While IE.Busy
    DoEvents
  Wend
  IE.Document.all("refreshthis").Click

works like a charm

________
clueless