In which activity you are using this code @yash.choursia
You have to use this code in Invoke VBA Activity which is the Excel activity, you have to use this activity inside the Use excel file activity.
Store the code in .txt file (Notepad file) and pass the the path of the .txt file in Code file path field.
Pass the Method name in the Entry Method Name field.
Check the below image for better understanding,
Notepad file -
Working on Pivot Tables.txt (547 Bytes)
Hope you understand!!