The Script Library
Menu
The Script Library
Browse
Search
Submit
Reference
About
Contact

Link to Us
Index
Display

Home VBScript Microsoft Office Microsoft Excel




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 on the left the screen..






Search The Library


Search String

Script Language