How to move excel sheet at the end using VBA script/code

Help Studio
, ,
21

Just to clarify this @Nishant_mantri

Have you added Get Workbook Sheets above Invoke VBA

So you need to use like

  • Excel Application Scope
    • Get workbook sheets and create a variable in the output properties as “Sheets” or what ever you want
    • Invoke VBA , In the input parameter you need to use your variable there
      like {“Sheet1”, YourVariable.Count.Tostring}

Regards
Sudharsan

22

Hi, I was getting this error… i have declared varaible as ‘sheets’ for Get workbook sheets activity

image
image1636×1010 98.3 KB

23

Try to update the package you have and try again as the below thread @Nishant_mantri

24

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