Copy data from webpage to excel using vba
I have an IE / Excel worksheet process that I am trying to automate via VBA.
Manually, the process looks like this:
1) Access the web page.
2) Since there is no way to convert to MS-Excel,
with the webpage in focus press CTRL-A, CTRL-C.
3) Select cell A1 in a blank worksheet.
4) Paste the contents of the Office clipboard into the Excel sheet.
I am able to access the webpage thru excel vba... but not able to do the select all copy part... can anyone help...
Thanks in advance...
|