I am trying to create the code to save a template down as a macro enabled workbook with a file name based on input from a userform. Here's what I have, and I keep getting an error message about the Workbook class. I've Googled a million times and some of what I have below is what I copied from recording a macro and still get an error - I am very stumped. Please help!
Private Sub submitbutton_Click()
Set newbook = Workbooks.Add("C:\Users\kate\Desktop\VBA\template.xltm")
With newbook
ChDir ("J:\Summary")
jobno = entryform.jobno.Value
.SaveAs Filename:="J:\Summary\" & jobno & ".xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Bookmarks