Excel Workbook SaveAs FileFormat
TemplateFile = "\\server\TemplateName.xls" Set objExcel = Sys.OleObject("Excel.Application") Set objWorkBook = objExcel.Workbooks.Add(TemplateFile) FileFormat = -4143 ...
Forum Discussion
Or you don't need call if you leave off the parenthesis
objWorkbook.SaveAs LogFileName, FileFormat
for a sub routine.
objWorkbook.SaveAs LogFileName, FileFormat
for a sub routine.