S
Sandy
The following 1) Save a workbook 'as' and then closes it - followed by 2)
the original book 'Not Saved' and then closing.
Is it possible to have the workbook 'saved as' without it closing and still
have the original book close without saving
ThisWorkbook.SaveCopyAs Filename:="Personal Data-" & inputText & ".xls"
ThisWorkbook.Close SaveChanges:=False
Sandy
the original book 'Not Saved' and then closing.
Is it possible to have the workbook 'saved as' without it closing and still
have the original book close without saving
ThisWorkbook.SaveCopyAs Filename:="Personal Data-" & inputText & ".xls"
ThisWorkbook.Close SaveChanges:=False
Sandy