|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Create a vb-script which opens your Excel workbook (maybe without displaying it at all), refreshes the query, and then saves and closes the workbook. And then run this script by Windows scheduled task.
Btw. Why you need to automate this at all? When someone uses the workbook to see the data, then you can set the query to SQL Server to be refreshed on open. When you query the data in Excel workbook, then why not query the data from SQL Server directly? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need vba code export data to closed workbook sheets | manilara | Excel Programming | 1 | 02-12-2016 08:20 PM |
OL2010: Your IMAP server closed connection | markg2 | Outlook | 0 | 12-17-2015 08:08 AM |
Your IMAP server closed the connection | emueyes | Outlook | 0 | 07-14-2013 11:38 PM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Refreshing Data in Excel | jamal420 | Office | 3 | 06-13-2005 03:45 PM |