This community has always been great in providing me solutions and i hope i will also for you in the future! Thank you for that.
I basically need to use all the excel activities Read Range, delete range etc but So i have such a scenario:
I open an excel file A.xlsx with the Excel Application Scope. In it i have to perform a macro which it opens me automatically another Excel B.xlsx.
The issue here is that I cannot work on B.xlsx because the Excel Application Scope in order for it to work has to open the file first and then perform other activities.
So my question here is , how could i “attach” to B.xlsx and perform Excel activities…
Dirty but if you can predict the Excel B name, you could attach its window, save the file in that window scope then use the saved path to use an Excel Application Scope