How to create / save a data table as a new worksheet in excel?
I can't figure out how to save a data table as a new worksheet in an excel file. I can create the Excel file if it doesn't exist, but I can't seem to create a worksheet inside of it. Here is what I have (sorry if it's a little sloppy): ExcelFilePath = "C:\Temp\";ExcelFileName = "WO " || "276" || " Summary.xls";Path = ""||ExcelFilePath||""||ExcelFileName||"";CurrentPart = "NewTab";Try( dtExis...
