Sign in to follow this  
Followers 0
rharwood

_excel question

6 posts in this topic

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???

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

$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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Everything is there.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0