Copy and paste into browser?

[JonathanB2]

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

[JasperD]

did you try the macro recorder?

[JonathanB2]

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.

[JasperD]

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 :

Sub Macro1()
'
' Macro1 Macro
'

'
    Sheets("Blad2").Select
    Range("E4:E10").Select
    Selection.Copy
    Sheets("Blad1").Select
    Range("C10").Select
    ActiveSheet.Paste
    Range("C19").Select
End Sub

then you can slim that down to 'proper' code with overhead stuff removed, like this :

Sub Macro1()
    Sheets(2).Range("E4:E10").Copy Destination:=Sheets(1).Range("C10")
End Sub

Does the same, simpler code :-)

[JonathanB2]

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....

[JasperD]

can you post a sample of your workbook?