+ Reply to Thread
Results 1 to 4 of 4

Adding a Refresh button to a worksheet

  1. #1
    Registered User
    Join Date
    05-03-2009
    Location
    Walnut Cove, NC
    MS-Off Ver
    Excel 2007
    Posts
    12

    Adding a Refresh button to a worksheet

    If I want to add a refresh button to a worksheet to update a web data query how would I do this?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,464

    Re: Adding a Refresh button to a worksheet

    Did you try using the macro recorder.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-03-2009
    Location
    Walnut Cove, NC
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Adding a Refresh button to a worksheet

    I am fairly new to the more complicated features of excel and do not have a clue of how to do that with the macro recorder I was hoping for a step by step.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,464

    Re: Adding a Refresh button to a worksheet

    Refresh web query:
    with a cell within the return web query results use ribbon
    Data > Connections > Refresh All > Refresh.

    Create macro:
    To record a macro use ribbon
    Developer > Code > Record Macro.

    (If the developer tab is not visible use
    Office Button > Excel Options > Popular > Top Options for working with Excel > Show Developer tab in the Ribbon)

    Once the recorder is started give the macro a sensible name like, RefreshMyWebQuery, and the record the action of refreshing a web query.

    Add button:
    To add a button to the sheet use ribbon
    Developer > Controls > Insert > Form Controls > Button
    Right click button and pick Assign Macro.
    Select your newly created macro from the list.


    Although given the button is there on the ribbon the creation of the button seems redundent.

+ Reply to Thread

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