Sign in to follow this  
Followers 0
devilman16

_excelreadcell from currently open Excel

3 posts in this topic

Hi,

I am looking for a solution to read some cells from a currently open Excel file.

This file is the result from a export of an other app and so I don't want to save this file first,

open it with _excelbookopen read the cells close it and delete the temp Exel file.

I tried it with _excelreadcell(WinGetHandle("Excel"), 4,4) but it don't works, is there a other solution?

Thanks for help

Share this post


Link to post
Share on other sites



Did you try $Excel=_ExcelBookAttach to get object from the exported wbook and then _excelreadcell($Excel,4,4) ?

Share this post


Link to post
Share on other sites

Thanks thats it!

br

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