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?