ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing web data to a worksheet (https://www.excelbanter.com/excel-programming/347730-importing-web-data-worksheet.html)

Sabo, Eric

Importing web data to a worksheet
 
Is it possible in a macro to import data from a web page to a worksheet?







Sabo, Eric

Importing web data to a worksheet
 
Basically what I want to do is some like when you go through (Data-import
external data-web query)

I just want to create a new worksheet and import external data to a new
created worksheet.

I saw this in a previous post:
ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://finance.yahoo.com/q?d=t&s=^DJI",
Destination:=Range("A1"))

"Sabo, Eric" wrote in message
...
Is it possible in a macro to import data from a web page to a worksheet?










All times are GMT +1. The time now is 03:00 AM.

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