Excel Workbook SaveAs FileFormat
TemplateFile = "\\server\TemplateName.xls" Set objExcel = Sys.OleObject("Excel.Application") Set objWorkBook = objExcel.Workbooks.Add(TemplateFile) FileFormat = -4143 ...
Forum Discussion
Both of those replies worked. I am still adjusting to vbscript and that was a rookie mistake.