ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   web query for Excel (https://www.excelbanter.com/excel-worksheet-functions/16735-web-query-excel.html)

QLS_KIM

web query for Excel
 

I need your help on Web Query function of Excel.

I have edited Import data macro “MSN Moneycentral Investor Quote.iqy”
file to fetch a value from a web page I have pointed and I got the
value I wanted. However, I have encountered a problem.

MSN Stock quote macro accesses the web page that supports multiple
input parameters and returns multiple values on one page, where the web
page I am working on returns one value per page.

In order for this macro to return multiple value I guess I have to use
some form of nested statement for the Web query and I do not know how
to do that.

Can you help please?


--
QLS_KIM


All times are GMT +1. The time now is 07:17 AM.

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