+ Reply to Thread
Results 1 to 1 of 1

Macro for automatically refreshing Data connection on Closed excel workbook.

  1. 11-23-2017, 01:23 PM #1
    Ramzan-ul-Mubarak
    Ramzan-ul-Mubarak is offline
    Registered User
    Join Date
    06-02-2017
    Location
    Lahore
    MS-Off Ver
    2010
    Posts
    22

    Question Macro for automatically refreshing Data connection on Closed excel workbook.

    Hy all.
    I need some help.
    I will be very grateful and will pray-full for any help.
    I don't know about using macros in excel.

    I am using excel 2013. I have a workbook which has connections to SQL Server for power query and pivot tables.
    I want that the data connections in work book may be refreshed at specific time intervals and workbook may be saved.
    Can some one please guide me for adding and enabling macro for this purpose.
    I am completely raw in adding macro. So please someone guide me completely with some example.
    I will be very much grateful for this help.
    Last edited by Ramzan-ul-Mubarak; 11-23-2017 at 01:28 PM.
    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. 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
  2. Excel Macro Copy Alph Numberic Data from a Closed CSV File to an Active Excel WorkBook
    By sanjaydutta20022 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2016, 10:33 PM
  3. Data connection not refreshing due to inserting row error
    By Hillsy7 in forum Excel General
    Replies: 2
    Last Post: 07-14-2015, 05:34 PM
  4. refreshing data connection erroring
    By 13lack13lade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2014, 03:08 AM
  5. Export data from closed workbook to active workbook with ADO connection
    By Naresh27 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-09-2013, 01:08 PM
  6. Get data from closed workbook - ADO connection
    By marzook in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2013, 01:43 AM
  7. Opening, refreshing, saving, and closing a closed workbook
    By hootiebsc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2013, 05:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1