[SOLVED] Excel Copy Sheet to Another Sheet

[maniootek]

Hi guys.

I was trying to copy one sheet from one workbook to another sheet in same workbook.

I success with this code:

$oExcel.Application.Sheets("Sheet1").Copy(Default, $oExcel.Application.Sheets("Sheet2"))

"Sheet1" was copied to "Sheet1(2)" which was located after Sheet2.

This is not exactly what I wanted. I want Sheet1 to be copied to Sheet2 without creating new sheet and changing sheet names. any idea?

I solved problem:

$oExcel.Application.Sheets("Sheet1").Copy(Default, $oExcel.Application.Sheets("Sheet2"))
_ExcelSheetNameSet($oExcel, "Sheet2")

Edited February 20, 2014 by maniootek

[water]

Delete Sheet2 before copying Sheet1?

[maniootek]

Delete Sheet2 before copying Sheet1?

if I do that then my copy function will not work because I need to determine after which sheet it will be copied

by the way, any way to change that copy function to copy BEFORE (not after) specified sheet ?

Edited February 20, 2014 by maniootek

[water]

My rewrite of the Excel UDF allows just this. Function _Excel_SheetCopyMove does what you need.

[maniootek]

My rewrite of the Excel UDF allows just this. Function _Excel_SheetCopyMove does what you need.

UDF is complicated because you have download it and declare it, I prefer to have build in functions. I also resolved my problem by add

_ExcelSheetMove($oExcel, "Sheet1", "Sheet2")

It will move "Sheet1" before "Sheet2"

Thank you @water anyway

Edited February 20, 2014 by maniootek

[water]

BTW: My rewrite will become the builtin Excel UDF in the next AutoIt beta.