Hi All,
I use the following code (found here) to do the following:
- Save
- Set up a Windows prompt that will re-open the Excel file in a few seconds
- Close the workbook
- Prompt triggers a re-opening of the workbook
Sub SaveCloseReOpen()
Dim strCMD As String
strCMD = "CMD /C PING...