+ Reply to Thread
Results 1 to 6 of 6

Copy and paste into browser?

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    72

    Copy and paste into browser?

    Hi everyone,

    I searched the forums already but this exact question wasn't answered (or I couldn't find it).

    I have a website linked in excel (webbroswer.navigate etc. etc.). This is on sheet 1. The data I want fed into the browser is in sheet 2. So I need to copy from sheet 2 (A1 through D200) into the browser of sheet 1 (the browser has a open field where text can be placed).

    I can manually copy and past the data into the field, so there has to be a way to do it with a macro (eventually, I just want to dump the data from sheet 2 into the field in sheet one with the click of a button).

    Any and all help is appreciated!

    Jon

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Copy and paste into browser?

    did you try the macro recorder?
    Please click the * below if this helps

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: Copy and paste into browser?

    Hmm....no (not entirely sure what that is). I had a macro that copied and pasted (into another spreadsheet) but I don't have it any longer. I'll google the macro recorder thingy. Thanks

    I may have trouble with a macro because if I say I want to dump xx data into xx cells, I'm not certain they'll drop them into the browser but behind the browser.

  4. #4
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Copy and paste into browser?

    The macro recorder is the built in excel function to make a macro of stuff you do...
    you start the macro recorder, do what you want the macro to do, then end it
    then you can see (and adjust) the macro it made.

    For example, if I use the macro recorder to select a few cells in sheet2 and put them in sheet1, the recorded macro looks like this :
    Please Login or Register  to view this content.
    then you can slim that down to 'proper' code with overhead stuff removed, like this :

    Please Login or Register  to view this content.
    Does the same, simpler code :-)

  5. #5
    Registered User
    Join Date
    08-06-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    72

    Re: Copy and paste into browser?

    Thanks for explaining. I tried this but it doesn't work for this (works wonders for other things though). It stops recording when I click in the browser field to paste. It works if I paste into other cells, but for some reason the "recording" button turns gray and stops automatically when I go to dump the data in the browser field. Perhaps this isn't possible to do....though I would think it's possible. Hmm....

  6. #6
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Copy and paste into browser?

    can you post a sample of your workbook?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste problem with browser open
    By DHW75 in forum Excel General
    Replies: 5
    Last Post: 04-20-2012, 09:47 PM
  2. Copy Strings into Web Browser?
    By Hlowmaster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2010, 08:36 PM
  3. Replies: 4
    Last Post: 05-18-2006, 11:25 PM
  4. how do I cut and paste from an e-mail on to browser
    By wellington in forum Excel General
    Replies: 0
    Last Post: 03-09-2006, 05:15 AM
  5. Replies: 4
    Last Post: 05-18-2005, 12:06 PM

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