Re: VBScript and Out Put to Excel Worksheet
- From: "Mike" <mikef2691@xxxxxxxxxxx>
- Date: Tue, 28 Jun 2005 07:50:02 -0500
Thanks, I'll give them a try.
Mike
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
"Richard Mueller [MVP]" <rlmueller-NOSPAM@xxxxxxxxxxxxxxxxxxxx> wrote in
message news:eX5sKK4eFHA.220@xxxxxxxxxxxxxxxxxxxxxxx
> Mike wrote:
>
>> I have been asked to come up with a method to inventory some servers and
> add
>> the output to an existing Excel
>> worksheet. I can create the worksheet and add "A" row of data, but I am
>> unsure as to how I would move to the
>> next row.
>>
>> The next question, of course is;
>>
>> Would it be possible to type in a server name in column 1 row 1 and have
> the
>> script execute and populate
>> the rest of the cells in Row 1 with the information gathered by a
> VBScript?
>> And then move down the list
>> populating as it goes?
>
> Hi,
>
> Here is a sample VBScript program that outputs user Distinguished Names to
> an Excel spreadsheet:
>
> http://www.rlmueller.net/Create%20User%20List%203.htm
>
> You refer to cells by row and column. In the code linked above:
>
> objSheet.Cells(i, j) = "Whatever"
>
> where i is the row and j the column. I increment the rows in a loop when I
> enumerate users. The first row is a heading.
>
> Also, you might want to use this example program, which uses WMI to
> inventory all computers in a domain. It also writes the output to an Excel
> spreadsheet.
>
> http://www.rlmueller.net/Inventory.htm
>
> For ADO search filter to retrieve all servers, see the code in this
> program:
>
> http://www.rlmueller.net/Enumerate%20Servers.htm
>
> and to search for all Domain Controllers:
>
> http://www.rlmueller.net/Enumerate%20DCs.htm
>
> --
> Richard
> Microsoft MVP Scripting and ADSI
> Hilltop Lab web site - http://www.rlmueller.net
> --
>
>
.
- References:
- VBScript and Out Put to Excel Worksheet
- From: Mike
- Re: VBScript and Out Put to Excel Worksheet
- From: Richard Mueller [MVP]
- VBScript and Out Put to Excel Worksheet
- Prev by Date: CreateUserList3.vbs
- Next by Date: Use WMI to Stop/Start the Default Web Site
- Previous by thread: Re: VBScript and Out Put to Excel Worksheet
- Next by thread: Re: VBScript and Out Put to Excel Worksheet
- Index(es):
Relevant Pages
|
