topic Re: Move action Excel VBO giving me the following Exception: Source worksheet not found in Product Forum

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

EstebanMontesin — Mon, 19 Jul 2021 03:44:04 GMT

I am trying to move one worksheet from one workbook to another. Any thoughts?

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

IsmoLehtiniemi — Mon, 19 Jul 2021 10:33:05 GMT

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.

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

ritansh.jatwani — Mon, 19 Jul 2021 10:53:36 GMT

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.

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

krishna.kodimurali9 — Mon, 19 Jul 2021 11:50:17 GMT

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