get data from webpage in excel

[auto]

hi, everyone;
i am having a code to navigate my IE browser to a webpage, and then from there i want the whole webpage to copy it into my excel sheet. can anyone help me with that?
webquery is not an answer! because i need to do some log-in and other functions till i get to that specific page that i need.
i made already all functions, but i get stuck when it comes to copy the page and paste it into excel, can anyone help me with some coding?

 

[auto]

let me give some idea what i tried and i am getting an error,

'this will select all'
ie.ExecWB 17, 0
'copy'
ie.ExecWB 12, 0
ie.Quit

'this is the target where the data have to go in'

xlSheet2.Activate
Range("A1").Select
Selection.PasteSpecial xlPasteValues

error pastespecial method of range class failed

any idea what is wrong?

 

[auto]

ok, got it, the problem was i need to write this,

xlSheet2.PasteSpecial xlPasteValues

now its working!!
xlsheet2 was set before as a range, so i didnt have to select it.

 

[Norie]

Just curious but why the entire page?

You could extract only the data you want from the page.

 

[auto]

did you have a way to select a specific place in the page and copy it using ie.ExecWB 12, 0?
if yes can you provide me the code?
really appreciated.

 

[Norie]

Not using ExecWB, but accessing the elements of the page, eg tables, and putting the data into Excel.

 

[auto]

can you give me some coding?
let say i need table 7
how will i do that?

 

[Norie]

It's hard to give any code without further details.

Apart from a few things, eg opening IE and navigating to the URL, the code will be different for each page/site.

 

[auto]

thanks for willing to help me, i will give you the source of my page where the table i need to extract, for security reasons i need to edit the shipping info, so i set that to john smith, basically i need that table it contains shipping address.
here it is.

<table class="data-display" cellspacing="1"><tbody> <tr class="list-row"> <td class="data-display-field" width=30% valign="top"><strong>Shipping Address:</strong><br>john<br>smith<br>1111 Example St.<br>Brooklyn, NY 12090<br></td> <td class="data-display-field" width=50% valign="top"> <table class="data-display" cellspacing="0" cellpadding="0"><tbody> <tr class="list-row"></pre>

 

[auto]

[TABLE="class: data-display"]
<tbody>[TR="class: list-row"]
[TD="class: data-display-field"][TABLE="class: data-display"]
<tbody>[TR="class: list-row"]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
k