|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
11-24-2017, 08:55 AM
|
|||
|
|||
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 |
Windows 8 
Office 2016
Threaded Mode