The below vbs code is run from a 'VBScript Script File'
It currently creates an excel file with one sheet that populates cell A1 with Field1,Field2,Field3
I would like to know how to:
-Create individual sheets for Field1,Field2,Field3, so the 1st sheet would be called 'Field1' and would have 2 columns: Field1, Description
The field list needs to be dynamic, so any number of fields can be passed into the vbs script.
I have attached an example of the output excel file.
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)
xlApp.visible = True
'optionally make the sheet visible
'xlSheet.Application.Visible = True
xlSheet.Cells(1,1).Value = "Field1,Field2,Field3"
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing