Sign in to follow this  
Followers 0
maniootek

[SOLVED] Excel Copy Sheet to Another Sheet

6 posts in this topic

#1 ·  Posted (edited)

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

Delete Sheet2 before copying Sheet1?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

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

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

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  
Followers 0