Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » Adsi

Add Formatted Data to a Spreadsheet in Windows

You can use any of the VBScript programs below in ActiveXperts Network Monitor. Click here for an explanation about how to include scripts in ActiveXperts Network Monitor.

Add Formatted Data to a Spreadsheet in Windows using VBScript, WMI and LDAP

Example(s)

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