A simple workaround is to use a macro to open a new workbook i.e Workbooks.Add and then use the macro to save it as a .xlsm file in same or set path with say the date in the string. Once it has been closed and then reopened it can be changed. I prefer it this way to avoid users forgetting the file name.
It might be frustrating but I cant wait for the next version.
The full code example is
Dim XLSPadlock As Object
Set XLSPadlock = Application.COMAddIns(“GXLSForm.GXLSFormula”).Object
Filepath = XLSPadlock.PLEvalVar(“EXEPath”)
If Dir(Filepath & “DATA EXPORT”, vbDirectory) = “” Then
MkDir Filepath & "DATA EXPORT"
'Set file name of destination workbook
strFile = " Data " & " Exp " _
& Format(Now(), “dd mm yy hh mm”)
strFile = Filepath & “DATA EXPORT” & strFile
Set XLSPadlock = Application.COMAddIns("GXLSForm.GXLSFormula").Object 'need to restate else next line may fail
XLSPadlock.SetOption Option:="1", Value:="1"
ActiveWorkbook.SaveAs Filename:=strFile, ReadOnlyRecommended:=False, CreateBackup:=False
XLSPadlock.SetOption Option:="1", Value:="0"
Do procedures then