Add Formatted Data to a Spreadsheet Description
Demonstration script that adds the words "test value" to a new spreadsheet, then formats the cell containing the value. Author/Submitter
Microsoft Scripting Guys Supported Platforms | Windows Server 2003 | Yes | | Windows XP | Yes | | Windows 2000 | Yes | | Windows NT 4.0 | Yes | | Windows 98 | Yes | VBScript Code
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
objExcel.Cells(1, 1).Value = "Test value"
objExcel.Cells(1, 1).Font.Bold = TRUE
objExcel.Cells(1, 1).Font.Size = 24
objExcel.Cells(1, 1).Font.ColorIndex = 3
Was this helpful? If so, Please Share it by clicking a button below..
 Search The Library
|
