Copy Excel Worksheet from one Workbook to another with Powershell

Question:

I’d like to copy (or move) a worksheet from one workbook to another workbook with Powershell.

I had done this before and cant remember how. I think I used CopyTo() function.

Just to get started.

Answer:

See post from Kiron

Changed index to copy to second sheet:

Source:

Copy Excel Worksheet from one Workbook to another with Powershell by licensed under CC BY-SA | With most appropriate answer!

Leave a Reply