Create New Excel File
Program to create a new Excel workBook
set xl=createobject("excel.application")
set wb=xl.workbooks.Add
Set ws=wb.worksheets(1)
ws.Name="New Name"
ws.cells(1,1).value="Completed creation of new excel file"
wb.saveas ("C:\1.xlsx")
wb.close
xl.quit
No comments:
Post a Comment