_excel question

[rharwood]

In my script I am updating a excel shreadsheet based on data I receive from a serial port, This part works fine, My question is can I change focus to the cell that I am updating so that the user can see the updating on the screen???

[picaxe]

$oExcel.ActiveSheet.Range("A15").Select ; select or set focus to cell A15

[rharwood]

$oExcel.ActiveSheet.Range("A15").Select ; select or set focus to cell A15

Thank picaxe worked like a charm , where are these calls documented so I can look them up

[picaxe]

Thank picaxe worked like a charm , where are these calls documented so I can look them up

You are welcome, I use the Excel vba editor help file and the object browser. Viewing code generated by the Excel macro recorder is also helps.

[rharwood]

You are welcome, I use the Excel vba editor help file and the object browser. Viewing code generated by the Excel macro recorder is also helps.

I guess I'll have to find my disk , I dont have the help fill installed

[Juvigy]

You can also check the excel VBA reference on the msdn.microsoft.com.

Everything is there.