+ Reply to Thread
Results 1 to 2 of 2

Paste Data into Webpage and click Button

Hybrid View

Gannon2145 Paste Data into Webpage and... 08-02-2012, 10:37 AM
Jocher72 Re: Paste Data into Webpage... 02-13-2015, 07:33 AM
  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Paste Data into Webpage and click Button

    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

  2. #2
    Registered User
    Join Date
    02-13-2015
    Location
    Italy
    MS-Off Ver
    Office 2007
    Posts
    1

    Re: Paste Data into Webpage and click Button

    Hi, i'm intrested to resolve this question....have you find solution?

    thank's

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1