Currently i have a vb statement that will copy a sheet and then save it to a certain location.
what im interested to do is to set it up so when i click the button the first is called 1, then 2 etc.
Also is it possible to save them as the current date and time??
my current code is below.
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\SCH\1.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _