Hi all,

I'm trying to save the current template as a new file the code I'm using is

NewFileName = Application.GetSaveAsFilename(NewFileName, "Excel Macro Enabled Workbook (*.xlsm), *.xlsm")
    Call ActiveWorkbook.SaveAs(NewFileName, xlOpenXMLWorkbookMacroEnabled)
it opens a save file dialog with all the details in but the user could edit the name or location so i want to stop the dialog and just save it

kind regards tim