+ Reply to Thread
Results 1 to 4 of 4

Update Query Url: Excel 2016 Query

  1. #1
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Update Query Url: Excel 2016 Query

    Hi - I'm a novice programmer, and I'm having a difficult time figuring out how to update a query Url.

    Can someone please help me with the code? Example workbook attached. I need a code to change the current URL: http://chart.finance.yahoo.com/table...=d&ignore=.csv

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Update Query Url: Excel 2016 Query

    Where is the code which produces the table? I have seen it many times on this site.

  3. #3
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Re: Update Query Url: Excel 2016 Query

    The table is generated from the query. On excel 2016, click on the table, query tab, and if you change the source manually, the table will update. But i will need to know how to update the URL.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Update Query Url: Excel 2016 Query

    I do not have power query and cannot the code. The code I was referring was a different one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. automate power query update from new tab (office excel 2016)
    By ajnuna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2016, 07:27 AM
  2. Update query via Excel VBA - incorrect Sql statement
    By Hendrik Soede in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2013, 07:03 AM
  3. Update Query Not Working. "Operation must use an updateable query"
    By jdgwebdev in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-19-2013, 01:19 PM
  4. Running Access Update query from Excel
    By vish2025 in forum Access Tables & Databases
    Replies: 2
    Last Post: 10-26-2010, 08:53 AM
  5. Update Excel query value from Sheet
    By jribeiro in forum Excel General
    Replies: 2
    Last Post: 08-05-2009, 06:58 PM
  6. [SOLVED] Running a SQL Update Query in Excel VBA
    By KC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2006, 06:35 PM
  7. How do I update a ODBC query in Excel using pivotTables in VBA?
    By FCS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-10-2005, 12:55 PM

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