This Macro is courtesy of the Allen Wyatt Website, it works just fine, with the exception that instead of it saving to the root directory of C: I would like to put the result in a directory for example
C:Breakout, I tried Const WBPath = "C:Breakout " but it does not work, any ideas please
Dim sht As Worksheet
Dim NFName As String
Const WBPath = "C:"
For Each sht In ActiveWorkbook.Worksheets
NFName = WBPath & sht.Name & ".xls"
ActiveWorkbook.SaveAs FileName:=NFName, _