Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    40

    Unanswered: Trying to download spreadsheet

    I am trying to create a simple program that will grab the spreadsheet link from Yahoo Finance and populate a table in an Access 2003 database I have developed. When I try to use the code below I get the error: "Invalid Internet Address"(3651) Here is the code I am using:

    Private Sub Command3_Click()
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Assets", "http://finance.yahoo.com/d/quotes.csv?s=TIBX,ATVI,LOOK,CHRT,ORCL,CLST,RADA,SG I,TIVO,SCH,LU,HP,NFLX,CREAF,KKD,BIZ,%5EIXIC,%5EDJI ,%5EGSPC&f=st5l9c6p4b1a3&e=C:\Temp\test.csv", False, "a1:G1", False

    End Sub

    Any help would be appreciated

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    is there any way you can download the file, update it and then upload it again?

  3. #3
    Join Date
    Dec 2003
    Posts
    40

    Right now...

    I just want to download the file. I am trying to add it to a table and then manipulate the data.

Posting Permissions

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