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?