I have a workbook with a connection. I have gone to connection properties and set it to refresh periodically in the background. But I don’t know if it saves the document after the refresh. I don’t think so because the time of last modification of document doesn’t change.
So I’m trying to automate opening the workbook refresh, then save and close all in the background. I’m also looking into batch files and automating it that way. But I’m also wondering if there is a macro to do the same?
Any help would be greatly appreciated!
Thanks in advance!
So I’m trying to automate opening the workbook refresh, then save and close all in the background. I’m also looking into batch files and automating it that way. But I’m also wondering if there is a macro to do the same?
Any help would be greatly appreciated!
Thanks in advance!