rharwood Posted February 12, 2010 Share Posted February 12, 2010 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??? Link to comment Share on other sites More sharing options...
picaxe Posted February 12, 2010 Share Posted February 12, 2010 $oExcel.ActiveSheet.Range("A15").Select ; select or set focus to cell A15 Link to comment Share on other sites More sharing options...
rharwood Posted February 12, 2010 Author Share Posted February 12, 2010 $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 Link to comment Share on other sites More sharing options...
picaxe Posted February 12, 2010 Share Posted February 12, 2010 Thank picaxe worked like a charm , where are these calls documented so I can look them upYou 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. Link to comment Share on other sites More sharing options...
rharwood Posted February 12, 2010 Author Share Posted February 12, 2010 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 Link to comment Share on other sites More sharing options...
Juvigy Posted February 12, 2010 Share Posted February 12, 2010 You can also check the excel VBA reference on the msdn.microsoft.com. Everything is there. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now