How to execute macro in particular sheet?

[PALKUMARI_PATEL]

I want to execute macro which is saved in excel file and I have to go to particular sheet to execute it.

[copy_writes (chethan)]

1. Open Excel File: Use the “Excel Application Scope” activity to open the Excel file. Provide the file path as an input.
2. Navigate to Sheet: Inside the “Excel Application Scope,” use the “Select Range” activity or “Excel Read Range” activity to navigate to the specific sheet you want to work with. Alternatively, you can use the “Activate” activity to activate the sheet.
3. Invoke VBA: After navigating to the sheet, use the “Invoke VBA” activity to execute the macro. Provide the path to the Excel file and the macro name as inputs. You can also pass any required parameters.

[copy_writes (chethan)]

Or Follow the below solution

Execute Excel Macro within specific sheet of workbook

Hi @tmcwade12 , Could you check with the below Modified Code : Sub CompleteMacro() ’ ’ CompleteMacro Macro ’ ’ For Each ws In ThisWorkbook.Sheets ws.Activate Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True Columns("G:G").Select Selection.TextToColumns Destina…

[PALKUMARI_PATEL]

Excel read range is not navigating to the sheet. Can you suggest something else?