I have created a macro to save my excel workbook as a .csv every 5mins, however I would also like to refresh the workbook before each save.
To do this, I have a 'refresh' macro and a 'repeated saving' macro (Shown below)
Both Macros work when used separately, however the workbook will not refresh when the macros are combined.
Any ideas why this is?
Refresh Macro:
Repeated saving macro:Please Login or Register to view this content.
Edit: I've since created a vbscript to do what i wanted instead of using macros, but im still curious as to why this doesnt work.Please Login or Register to view this content.
Bookmarks