OK as I said, I'm very new to all this
I've attached the code of what I have so far.
@Jochen: I appreciate what you say, but I don't understand it.
What's the difference in what you say, and what I do?
code:
$xlfilename = "\\server\memory\memory.xls"
$oXL = CreateObject("EXCEL.application")
$ws = @WKSTA
$mem = Val(WMIQuery("TotalPhysicalMemory","Win32_LogicalMemoryConfiguration"))/1024
$cpu = WMIQuery("CurrentClockSpeed","Win32_Processor")
If @error = 0
$oXL.Visible = 1
$Rc = $oXL.Workbooks.open ($xlfilename)
$array = "Workstation", "CPU", "Memory"
$oXL.Range("A1:C1").Value = $array
$oXL.Cells(1).Value = $ws
$oXL.Cells(2).Value = $cpu
$oXL.Cells(3).Value = $mem
$Rc = $oXL.Range("A1:C1").EntireColumn.AutoFit
[ 15. July 2003, 14:54: Message edited by: codacs ]
_________________________
the trouble with doing nothing, is that you can't stop to take a rest.