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.

@gregelliott

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)
Etc…

@lakshman
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

@gregelliott

No.

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.

Regards
Balamurugan.S

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