ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Web query question (https://www.excelbanter.com/excel-programming/310679-web-query-question.html)

KC Lim

Web query question
 
Hi,

Need to have an easy way to pull data from web. Using the
example provided (Microsoft Money Stock Quotes), how do I
go about to just extract the row where the stock info is,
and forget about the header, footer and others?

Anyone with experience in this? Appreciate your help.

Thanks.



Tom Ogilvy

Web query question
 
Why not get what you get with the web query and then use a macro to remove
the information you don't want.

--
Regards,
Tom Ogilvy

"KC Lim" wrote in message
...
Hi,

Need to have an easy way to pull data from web. Using the
example provided (Microsoft Money Stock Quotes), how do I
go about to just extract the row where the stock info is,
and forget about the header, footer and others?

Anyone with experience in this? Appreciate your help.

Thanks.





KC Lim

Web query question
 
Problem is I have multiple queries, each of which I am
interested in a row in the result set.

I'll try your suggestion and see what issues I encounter.

Thanks.


-----Original Message-----
Why not get what you get with the web query and then use

a macro to remove
the information you don't want.

--
Regards,
Tom Ogilvy

"KC Lim" wrote in

message
...
Hi,

Need to have an easy way to pull data from web. Using

the
example provided (Microsoft Money Stock Quotes), how do

I
go about to just extract the row where the stock info

is,
and forget about the header, footer and others?

Anyone with experience in this? Appreciate your help.

Thanks.




.



All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com