A
Alex Turner
Anyone knows why this does not work - i.e. the even sink
excel_SheetChange never fires?
Dim myExcel,myWorkbook,mySheet
Set myExcel=WScript.CreateObject("Excel.Application","excel_")
Set myWorkbook=myExcel.Workbooks.Add()
Set mySheet=myWorkbook.Sheets(1)
myExcel.Visible=TRUE
myExcel.EnableEvents=TRUE
While myExcel.Visible
WScript.Sleep(100)
Wend
Sub excel_SheetChange(ByVal Sh, ByVal Target)
WScript.Echo "Sheet Change: Sheet=" & Sh.Name & ", Range=" &
Target.Row & "," & Target.Column
End Sub
Any help welcome. If I get this to work I'll be posting about it on my
blog. I've been wanting to sink Excel events to vbscript for ages and
just don't seem to be able to manage
Thanks!
AJ
excel_SheetChange never fires?
Dim myExcel,myWorkbook,mySheet
Set myExcel=WScript.CreateObject("Excel.Application","excel_")
Set myWorkbook=myExcel.Workbooks.Add()
Set mySheet=myWorkbook.Sheets(1)
myExcel.Visible=TRUE
myExcel.EnableEvents=TRUE
While myExcel.Visible
WScript.Sleep(100)
Wend
Sub excel_SheetChange(ByVal Sh, ByVal Target)
WScript.Echo "Sheet Change: Sheet=" & Sh.Name & ", Range=" &
Target.Row & "," & Target.Column
End Sub
Any help welcome. If I get this to work I'll be posting about it on my
blog. I've been wanting to sink Excel events to vbscript for ages and
just don't seem to be able to manage
Thanks!
AJ