Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA
Minor bug fixes in comments to some columns. Download and unpack to C:\Power Refresh.
Better control over workstation resources. Limit number of Excel sessions, or assign heaviness-values to each report and limit total available resources. Schedule by Months, set Month Calendar or Month Working days. Terminate reports with all dependent processes. Improved design of ControlPanel, better colouring, better grouping of functions.
Starting from this release schedule on month calendar and working days is available. Email notifications about terminated tasks, mailing settings, new parameters, proper time limit control over parallel tasks.
Improved stability of Reports Controller, added support of [Time Limit] + email notification about exceeded time.
Added option to refresh query on each X working days. Added Test Sample with Power Query from Web.
Removed component "scriptcontrol", it is not available for 64bit version. Replaced with custom Encode/Decode Url functions.
Initial version of Power Refresh as Excel solution. Can execute refresh of files on local drive / network drive / SharePoint. Execution with "Refresher" can be triggered from VBScript with parameters (sample included). VBS itself can be triggered by Windows Task Scheduler.
Issues: Cannot refresh Folders yet Limited work of internal Scheduler tons ideas for improvement