+ Reply to Thread
Results 1 to 2 of 2

Refreshing data connections

Hybrid View

superchew Refreshing data connections 12-20-2014, 05:05 PM
Olly Re: Refreshing data... 12-20-2014, 07:19 PM
  1. 12-20-2014, 05:05 PM #1
    superchew is offline
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Refreshing data connections

    is there VBA for automatically refreshing data connections on workbook open?
    Reply With QuoteRegister To Reply
  2. 12-20-2014, 07:19 PM #2
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Refreshing data connections

    Put this in the workbook module:

    Private Sub Workbook_Open()
    ThisWorkbook.RefreshAll
End Sub
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking Data / Refreshing Existing Connections Issue
    By gingerbug in forum Excel General
    Replies: 3
    Last Post: 12-11-2014, 12:12 PM
  2. external data connections are not refreshing even with VBA
    By krishna2221 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 04:00 AM
  3. [SOLVED] Opening, refreshing data connections, saving and closing file with VBA
    By jtukes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 03:31 PM
  4. Data Connections : Saving history before refreshing?
    By brianlg in forum Excel General
    Replies: 0
    Last Post: 10-10-2013, 12:07 PM
  5. Refreshing workbook connections
    By Thamizh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2010, 01:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1