VBScript to Control Excel Spreadsheet
'==========================================================================
' NAME: VBSCriptControlExcel.vbs
' AUTHOR: Neal Walters
' DATE : 3/19/2006
' http://VBScript-Training.com
'
'==========================================================================
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
objExcel.Cells(1, 1).Value = "Fred Flinstone"
objExcel.Cells(1, 2).Value = "Bedrock"
objExcel.Cells(2, 1).Value = "Barnie Rubble"
objExcel.Cells(2, 2).Value = "Bedrock"
objExcel.Cells(1, 1).Font.Bold = TRUE
objExcel.Cells(1, 1).Font.Size = 14
objExcel.Cells(1, 1).Font.ColorIndex = 3
|