Results 1 to 4 of 4

Refreshing only connection query

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    922

    Refreshing only connection query

    Hello

    only connection query can't be refreshed so that mean its always updated?
    mean if "A" table is only connection query
    and query "B","C","D" (loaded in worksheet query) Taking data between them and "A" table
    anytime I refresh "B", the "A" will be ready and always updated?
    I am refreshing queres manully by VBA and evrytime I refresh A before others like this
    ActiveWorkbook.Connections("Query - A").Refresh
    ActiveWorkbook.Connections("Query - B").Refresh
    Shall I remove refreshing A?

    note: "A" query is geting data from same workbook table
    Last edited by Undo; 03-31-2023 at 08:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Skip refreshing connection if Parameter is left blank
    By scorziello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2021, 07:44 PM
  2. Linked Connection Table opening original workbook when refreshing
    By ShameyWinehouse in forum Excel General
    Replies: 3
    Last Post: 08-23-2018, 11:01 AM
  3. Establishing ODBC connection and refreshing data using Macro/VBA
    By jpark006 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2016, 03:15 AM
  4. Replies: 2
    Last Post: 07-14-2015, 05:34 PM
  5. refreshing data connection erroring
    By 13lack13lade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2014, 03:08 AM
  6. Editing Connection Strings and refreshing Pivot Tables
    By fadydaddy in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 06-03-2012, 04:29 PM
  7. Refreshing Web Connection that requires login
    By RubberDuckey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2011, 03:59 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