How to Get already opened Excel #2


#1

Hi Expert,

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.

  1. Open Excel file from web page, that must not be saved to local.
  2. Change some part based on Excel information, and use a Macro in the Excel.
  3. 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,
J,


#2

Attach Window to Excel, Send Hotkey Alt + F2 which pops-up the Save As dialog, type a path, to a temporary location (Get current directory, etc), Excel Application Scope, clean up the file. etc.