Hi All,
I have a macro that loops through and opens one excel file at a time (from a folder of many), refreshes all, saves as the current date, and then closes. When it tries to save, close, and move on to the next file I get the error saying "Action will cancel pending refresh command. Do you want to continue?" I tried adding DoEvents, with no luck. Any suggestions?
Please Login or Register to view this content.
Bookmarks