If I record the macro, I'm getting as below but I have few steps before
that, I want to merge the both can u pls help me on that.
I want to copy the values from the excel to the webpage and the result
table I should paste in the excel sheet. Below i have mentioned the details
Recorded Macro
try to run the macro which add the data table first and then add
wait or load statement at the end ( before end sub) and call the web query
macro to download the data
or try these macros
http://dailydoseofexcel.com/archives/2006/11/29/html-tables/
Go to Data menu option and select in Get External Data From WEB
and simply record macro your self.
.
Enjoy
Team XLS
On Sat, Sep 28, 2013 at 11:34 AM, Menaka Balakrishnamoorthy
menaka.balakris...@gmail.com wrote:
HI,
I want to take the data from the webpage
Website...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Saturday, September 28, 2013 11:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take the data from the webpage table and
paste it in the