Unable to use copy and paste worksheet as range action

[Divija]

Hi Team,

When am trying to use opy and paste worksheet as action getting the following error "Failed to copy worksheet: Invalid index. "

please find the screen shot for reference and help me out on the same.

View attachment 1533029495549.png

View attachment 1533029555522.png

 

[VJR]

Hi Divija,

In the Source Workbook and Destination Workbook parameters you need to give the [Workbook Name].
This workbook name will be derived as an Output parameter from the 'Open Workbook' action of Excel VBO.
Fix that and it should work.

 

[Divija]

Hi VJR,

I dont want to copy and paste from the same workbook but not diff sheets in that scenario ur logic will wotkout but i want to copy from one sourcr file sheet1 to another source file sheet2. Even if i want to copy and paste data from same workbook but diff sheets also am not getting the output.

View attachment 1533033898270.png

View attachment 1533033950442.png

View attachment 1533033972582.png

 

[VJR]

Hi Divija,

Irrespective of whether its the same workbook or not, the Source/Destination Workbook parameter does not take the full file path.
Just like you created the CopyWB for the source workbook you need to create another one for the destination workbook and it should work fine.

 

[Divija]

Hi Divija,

Irrespective of whether its the same workbook or not, the Source/Destination Workbook parameter does not take the full file path.
Just like you created the CopyWB for the source workbook you need to create another one for the destination workbook and it should work fine.

Yes i got the logic...
thanks alot for helping... have one more queery wen am trying to spy elements i am unable to see the attribute properties in the application modeller.

Do i need to do any setting to see the properties..