How to open a particular sheet on foreground?

I have a excel which contains two sheets refer the screenshot

Every time i need to open one sheet in foreground ?
How to dynamically open the sheet every time?

Thanks in advance

Hey! Welcome to community…

Try like this…

1.Get workbook sheets -ListSheets
2.For each loop pass the ListSheets
3.Take one if condition

Item.Contains("YourSheetName")

In then block use Excel Application scope provide the file path

Then take read range from excel

1.read the excel -Dtout

This will open the sheet in foreground which we provided in the if condition

Try this and let me know

Regards,
NaNi

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