Script to Port results to Excel

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Script to Port results to Excel

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Scripting Technologies] >> General Scripting >> Script to Port results to Excel

Page: [1]

Message

<< Older Topic Newer Topic >>

Script to Port results to Excel - 4/14/2008 11:33:43 AM

jr2

Posts: 21
Score: 0
Joined: 11/30/2004
Status: offline

I'm looking to, at the end of my script, gather the computername/IP and port the information out to an Excel spreadsheet on a shared folder.

TIA...

Post #: 1

RE: Script to Port results to Excel - 4/15/2008 10:34:10 AM

rbennett806

Posts: 603
Score: 8
Joined: 6/14/2006
Status: offline

What script language?

It sounds like you've already got a script that gathers the info, so you basically just need to save the information in a comma separated format and Excel can open and use it.

Just a quick rough example using VBScript...
Set strReportFile = objFSO.CreateTextFile("MyInformation.csv")
strReportFile.WriteLine Variable1 & "," & Variable2 & "," & Variable3

(in reply to jr2)

Post #: 2

RE: Script to Port results to Excel - 5/4/2008 11:19:43 PM

jhinkle

Posts: 54
Score: 0
Joined: 1/17/2002
Status: offline

That's how I would do it, though I got out of that business years ago. Out of curiosity, what caused you to want to gather that information that way?

_____________________________

Joseph Hinkle

http://myitforum.com/cs2/blogs/jhinkle

(in reply to rbennett806)

Post #: 3