Automate Workbook Refresh
Does anyone have a way to automatically refresh a workbook and save it to a file folder? We have a workbook that is highly formatted and has multiple queries on one worksheet so the reporting agent as I understand it won't help me, but let me know if I am wrong. Any ideas will be appreciated.
Thanks in advance.
Pete Knoer replied
When you write "automatically", do you mean on a scheduled basis without human intervention?
The only method I have ever seen to do this requires:
+ you have a PC running, network connected
+ you use Visual Basic + the Excel "ontime" method
+ you "somehow" need to pass to the Visual Basic code a valid userID & password (this does not have to be in the code, per se, but it has to be somewhere ... in the workbook, in another file, et cetera)
+ If your system puts out system messages at logon, you will need ANOTHER application running that monitors for this system message and dismisses it.
In short, it is relatively complex. I have developed the code for doing all of this. But ... In practice, I have always found it better to give an assistant the task to run something like this (assuming it is large) over their lunch break instead.