Script to Port results to Excel (Full Version)

All Forums >> [Scripting Technologies] >> General Scripting



Message


jr2 -> Script to Port results to Excel (4/14/2008 11:33:43 AM)

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...




rbennett806 -> RE: Script to Port results to Excel (4/15/2008 10:34:10 AM)

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





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

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?




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.875