So I have written a macro that automatically selects a whole sheet of data from my workbook, copies it to the clipboard, and opens up a webpage (BatchGeo.com). From there, the user has to manually click on the input box, paste the data, and click the "Map Now" button. I would like to automate this process. Basically, I want the user to be able to run the macro from within the excel workbook, and it copies the data, opens batchgeo, pastes the data, and clicks the map now button. Here is the macro I have so far:
Sub CopyToBatchGeo()
Rows("2:2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
ActiveWorkbook.FollowHyperlink Address:="http://www.BatchGeo.com", NewWindow:=True
End Sub
Bookmarks