Jump to content
Sign in to follow this  
maniootek

[SOLVED] Excel Copy Sheet to Another Sheet

Recommended Posts

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.

sheet1-2.png

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 by maniootek

Share this post


Link to post
Share on other sites
water

Delete Sheet2 before copying Sheet1?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
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 by maniootek

Share this post


Link to post
Share on other sites
water

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
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 by maniootek

Share this post


Link to post
Share on other sites
water

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×