Forum Discussion

mfoster711's avatar
mfoster711
Regular Contributor
13 years ago

Excel Workbook SaveAs FileFormat

TemplateFile = "\\server\TemplateName.xls" Set objExcel = Sys.OleObject("Excel.Application") Set objWorkBook = objExcel.Workbooks.Add(TemplateFile) FileFormat = -4143 ...
VLapidus's avatar
VLapidus
Frequent Contributor
13 years ago
You forgot to use Call:



Call objWorkBook.SaveAs(LogFileName, FileFormat)