Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Automate Workbook Refresh

Hi All,

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.

Former Member
Former Member replied

Hi Jason,

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.

- Pete

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question