Does anybody know how to read range from a Excel file whose window has already opened? I’ve read the same topic here: How to Get already opened Excel but it doesn’t teach me how to do it…
In my case, there is 3 step to do.
- Open Excel file from web page, that must not be saved to local.
- Change some part based on Excel information, and use a Macro in the Excel.
- Close that Excel.
In step 2, I need get Excel information to change some part of it but I cannot get data from Excel unless by using non-Excel application scope activity, it bit tough work… If anybody know how to read Excel file information that is not saved in local, please let me know.
thanks in advance,