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/
http://stackoverflow.com/questions/12989687/fetc
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 :
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 w
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 ex