Excel file + Multiple Sheets + Always open on first sheet + VBA

[Sairam_RPA (Mr.Robot)]

I have a excel file with multiple sheets. I do some operations on all sheets and save the file.

When the bot saves and opens the file it opens on the last saved sheet. Like below

But user always wants to open the excel file on the first sheet. Like below

Can anyone help me with this…

I tried using VBA as below:

Sub FistSheet()
Worksheets(“Test1”).Activate
End Sub

But this is not working…

[athira.somasekharan]

Hello @Sairam_RPA ,

Did you try this vba code?

Open the specific sheet from the excel

Hi, If you see I have multiple sheets in the excel, But I while reading and opening, I want to see only the particular test sheet in excel. Here what happened I am reading the test sheet but when I open the excel it show me the Sheet1 only. But I want to open only the test sheet on screen and perform some operation. But automatically it open Sheet1 only. How can I open always specific sheet from the excel? [image] @Palaniyappan @HareeshMR

Thanks!
Athira

[Aleem_Khan (Aleem Anwer)]

Which one solution for this post

[Sairam_RPA (Mr.Robot)]

Use the below code in invoke code.
Then pass your input file in in_Path argument in invoke code activity

Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Dim ws As Microsoft.Office.Interop.Excel.Worksheet
excel = New Microsoft.Office.Interop.Excel.Application
wb = excel.Workbooks.Open(in_Path)
excel.Visible = False
ws = CType(wb.Sheets(“Sheet1”), Microsoft.Office.Interop.Excel.Worksheet)
ws.Activate()
wb.Save()
wb.Close()
excel.Quit()