Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RE: Importing External Data (XP SP1)

    I'd like to use the Data>Import External Data>New Web Query facility in Excel to import historic share prices from Yahoo. How can I save the instructions/file that will enable me to do this automatically without having to go through all the steps each time? Also, what's the difference between this and the >Import Data option. I guess I'm looking for a guide on how to implement this facility - if there's a document anyone can point me I'd appreciate that. Thanks.

    F

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Importing External Data (XP SP1)

    You should't have to redo the query building every time, you can click in the datarange, then choose Data, Refresh data.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Importing External Data (XP SP1)

    Yes, but where do I do that?

    F

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Importing External Data (XP SP1)

    After you have done the web query one time, then click any cell in the range where the query put the data to select it. Then click on the Data menu and select "Refresh Data" do do the query again.
    Legare Coleman

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Importing External Data (XP SP1)

    Thank's, all clear now. As an aside, where is the query stored and can I view the code?

    F

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: RE: Importing External Data (XP SP1)

    The query is stored with the workbook. You can click the "Edit Query" button on the External Data toolbar, or select Data | Import External Data | Edit Query... In the ;ast step of the wizard, select "View data or edit query in Microsoft Query". You can then view the SQL.

  7. #7
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Importing External Data (XP SP1)

    Thanks HansV. When I follow your instructions I get to the site but am unable to complete the last step, "View data or edit query in Microsoft Query", as that option is not there.

    F

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: RE: Importing External Data (XP SP1)

    MSQuery is not available for Web Queries. It is only really relevant to database queries (or files such as txt, csv or other Excel files).

    Queries are not code as such and are stored in the workbook. However they can be accessed via code, and if you would like to see the sort of code used you could record a macro whilst creating or editing the query, and then view the resultant code.

    Andrew C

Posting Permissions

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