List service data in a spreadsheet

Rate this article

Loading ...

April 1st, 2008 by

daniva

Print This Post

Local Search Results

You arrived here after searching for the following phrases:

in
Programming
Excel

Click a phrase to jump to the first occurrence, or return to the search results.

Demonstration script that displays the various colors — and their related color index — available when programmatically controlling Microsoft Excel

Set excel = CreateObject( "Excel.Application" )With excel   .Visible = True   .Workbooks.AddEnd Withx = 1Set wmiService = GetObject( "winmgmts:root\cimv2" )Set colServices = wmiService.ExecQuery( "Select * From Win32_Service" )For Each service in colServices   excel.Cells( x, 1 ) = service.Name   excel.Cells( x, 2 ) = service.State   x = x + 1Next    