Power-Refresh
Power-Refresh copied to clipboard
IvanBond
Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA
Hi Ivan, Congratulations for this great job! Can you help me on this? I have updated/refreshed my workbook witch as two sheets, sheet1 - get's pivotdata from sheet2 witch as...
latest code has into Starter.vbs Set objScriptEngine = CreateObject("ScriptControl") objScriptEngine.Language = "JScript" if I start Startes.vbs receive an error cannot create object ScriptControl. I see you removed ScriptControl. So, how...
Hello, first of all, thanks so much for a robust solution to exactly what you outlined in your notes. I'm having issues getting this to refresh a somewhat heavy PowerQuery...
Hi Ivan, First of all, a huge thank you for creating such a universal and robust solution. Using this together with BOA automation, and the whole package is a godsend....
64-Bit Excel has some issues with the Kill Child Prosses VB. this error will either cause Excel to Crash completely or debug out to the code
Idea: two new columns: 1) "Restart if Terminated" as Yes/No flag to tell controller if it needs to restart certain task after termination (whatever reason) (sometimes it is just enough...
Currently RC updates tracking file at each cycle - each minute. OneDrive sometimes can't handle such frequency, so need a configurable delay-parameter.
Think of adding an option to trigger execution of certain tasks/reports from MS Flow. Sample: Reports Controller is running on workstation with a gateway installed on it (alternative: onedrive folder,...
Add new parameters - Password for Opening workbook, Password for Saving workbook.