Read Range of Sheet Created By Excel Macro

I am executing a macro in excel which creates a new sheet. Is there a way to then read the new sheet with read range? the sheet name changes everytime because of the macro executed.


Create one variable of type Workbook for Excel Application Scope activity and then read sheets like this.

First sheet - varWB.GetSheets(0)
Second sheet - varWB.GetSheets(1)

yeah I have a workbook variable as an output from my excel application scope. Then use multiple assign activities is what you’re saying?

1 Like



If you want to read second sheet then use Read Range activity and mention sheet name as “varWB.GetSheets(1)”.

Hi @gregelliott,

If you don’t mind can you elaborate the situation step by step to know very clear.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.