There are times you may want a macro to save a file automatically after running a macro. The second macro will save the file with a name called "MyFile". You may specify the path if you need to.
Sub Save()ActiveWorkbook.SaveEnd SubSub SaveName()ActiveWorkbook.SaveAs Filename:="C:\MyFile.xls"End Sub
Subscribe for FREE Excel Items: