ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to define a web query in Excel&VBA?? (https://www.excelbanter.com/excel-programming/354409-how-define-web-query-excel-vba.html)

Dong Gaofeng

how to define a web query in Excel&VBA??
 
can anybody give me an example??



Nigel

how to define a web query in Excel&VBA??
 
The simplest would be to turn on macro recorder and use Data-Import
External Data-New Web Query
Use the VB editor to review the resultant code.

--
Cheers
Nigel



"Dong Gaofeng" wrote in message
...
can anybody give me an example??






All times are GMT +1. The time now is 10:13 AM.

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