In Excel 2016, I need a Macro to do the following: Open an Excel file, Refresh ALL the data-links, Save as another file (Renamed), close that file, and then
Save and close the original file that was opened. (How does the Macro know when ALL the data has been refreshed?) Is there an easy way to do this?
Thank you in advance for any help.