vba to change the dropdown choice on a webpage

cjcass

Well-known Member
Joined
Oct 27, 2011
Messages
683
Office Version
  1. 2016
Platform
  1. Windows
Hi,
Am looking to speed up the use of Wordle by changing some of the dropdowns using vba in Excel 2016.
The page is here... http://www.wordle.net/advanced
If you access this page (not via.Chrome, so use IE etc., it also requires Java) and copy this example text Tools:406.5:949494 into the second box on the page and press 'Go' you will see the word cloud produced in an applet. I currently have vba which gets me to this point but I can't work out how to automate changing the format of the cloud - am looking for vba to change the 'Font' dropdown to 'Vigo' and the 'Layout' dropdown to 'Horizontal'. Wordle doesn't remember your last format setting hence the need to be able to automate this with vba when producing lots of clouds with the same format. My code is below.
Any help much appreciated.

Code:
Dim IE As Object
Set IE = CreateObject("internetexplorer.application")
IE.Visible = True
IE.Navigate "http://www.wordle.net/advanced"


Do While IE.Busy: DoEvents: Loop
Do While IE.ReadyState <> 4: DoEvents: Loop


IE.Document.getElementByid("colorwordcounts").Value = _
      Sheets("Sheet1").Range("E17").Value


IE.Document.forms(1).submit 'form (1) relates to the 2nd form on the page


Do While IE.Busy: DoEvents: Loop
Do While IE.ReadyState <> 4: DoEvents: Loop
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
any help with this would be much appreciated...
 
Upvote 0

Forum statistics

Threads
1,223,968
Messages
6,175,677
Members
452,666
Latest member
AllexDee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top