several things going on. I have a macro that inserts date and a running
clock into cells A1 and A3 respectively. Looking to get code to insert
into this auto open macro so it just runs always... like the clock does.

want to get CPU time/CPU Usage of a certain process (test.exe for
example) and place that number (whole number as a percentage of 100)
into cell B2.

someone suggested to look at a french site for help,
So I looked here
http://www.vbfrance.com/codes/CLASSE...ATION-CPU-PROC
ESSUS_42392.aspx

Then I right clicked on the "cls"
and saw this
http://files.codes-sources.com/fichi...cessCPU%5cclsP
rocessCpuUsage.cls

but since I am DEAD flat novice at this (the auto open macro was found
on the net....not my invention), i am at a loss as how to accomplish the
task in VBA. i am not a programmer at all, dont know squat about it.

at most I record macros...not create them...

please help? Thank you so much


also to look at help I have gotten but didnt work....please look here
http://www.xtremevbtalk.com/showthread.php?p=1273191
Nothing will compile or produces no results


here is my Auto open macro:::::::::::

Dim SchedRecalc As Date
Sub Auto_open()
Dim wbk As Workbook
Dim ws As Worksheet

Set wbk = ThisWorkbook
Set ws = wbk.Sheets("Sheet1")

ws.Range("a1").Value = Format(Now, "dd-mmm-yy")
ws.Range("a3").Value = Format(Time, "hh:mm:ss AM/PM")

Call SetTime
End Sub

Sub SetTime()
SchedRecalc = Now + TimeValue("00:00:01")
Application.OnTime SchedRecalc, "Auto_open"
End Sub

Sub Disable()
On Error Resume Next
Application.OnTime EarliestTime:=SchedRecalc, Procedu="Auto_open",
Schedule:=False
End Sub



*** Sent via Developersdex http://www.developersdex.com ***