Evening all,

I'd like to create a macro in VBA which
1. copies data from an Excel worksheet range (say A1:C20)
2. Opens a new Internet Explorer window
3. navigates IE to www.batchgeo.com
4. pastes the data into the search box on that page
5. clicks the button labelled "Validate and set options"
6. clicks the subsequent button labelled "advanced options"
7. sets the checkbox labelled as "Enable clustering for high density markers" to TRUE
8. clicks the button on the page labelled "map now"

system specs: Windows 7, MS Excel 2010, IE9

Is anyone able to help with this? I've searched various threads but getting excel to talk to IE seems beyond my limited coding knowledge!

many thanks