Results 1 to 1 of 1

extract data from website to excel

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    Singa[pre
    MS-Off Ver
    Excel 2003
    Posts
    49

    extract data from website to excel

    Origin URL : http://ichart.finance.yahoo.com/table.csv?s=^dji&a=08&b=13&c=2011&d=06&e=6&f=2013&g=w&ignore=.xlsx
    In I1, put formula =TEXT(J1)
    In J1 ,put ^DJI,say. What's wrong with the following code ,plse?
    With Worksheets("Sheet1").QueryTables.Add(Connection:= _ "URL;http://ichart.finance.yahoo.com/table.csv?s=" & Cells(1, "I")&a=08&b=13&c=2011&d=06&e=6&f=2013&g=w&ignore=.xlsx"
    Last edited by Paul; 05-11-2012 at 04:02 AM. Reason: Rather than starting new threads, use the Edit Post button to modify the current one. I've fixed the CODE tags here.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1