cancel
Showing results for 
Search instead for 
Did you mean: 

Move action Excel VBO giving me the following Exception: Source worksheet not found

EstebanMontesin
Level 2
I am trying to move one worksheet from one workbook to another. Any thoughts?
3 REPLIES 3

IsmoLehtiniemi
Level 5
If you are sure that the worksheet name is correct, and if only data needs to be moved, you could try to use OLEDB -queries for selecting all data from the source worksheet, and then inserting it to the destination worksheet.

ritansh.jatwani
Level 9
Hi @Esteban Montesinos,

For moving a worksheet from one workbook to another, please follow the below steps:

1) Use "Copy and Paste Worksheet Range" action of MS Excel VBO to copy the data from one excel sheet to another.
2) Use "Delete Worksheet" action of MS Excel VBO to delete the worksheet from 1st workbook.

In this way, we have indirectly moved the worksheet from one workbook to another.​

You can refer below screenshot for Move Work Sheet, this works for me.

36342.png