Excel Workbook SaveAs FileFormat
TemplateFile = "\\server\TemplateName.xls" Set objExcel = Sys.OleObject("Excel.Application") Set objWorkBook = objExcel.Workbooks.Add(TemplateFile) FileFormat = -4143 ...
Forum Discussion
We've all make them. I am no rookie, and I still make them. I pulled an embarassing dumb bunny earlier this week. We all had a fun laugh at my mistake. I turn a very interesting shade of red when it happens. :)