Forum Discussion
Marsha_R
Champion Level 3
8 years agoLooks like there's a Copy feature available
https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheet_members.aspx
- Adagio8 years agoFrequent Contributor
Thanks Marsha! I'm looking for ways to do it using JavaScript in TestComplete.
Thank you
Abhi
- Marsha_R8 years ago
Champion Level 3
If you look here
There's an example of javascript with Excel.Workbooks
The link I sent you above explains another object Excel.Worksheet, that has a Copy available. Take a look at those pages and see if you can work it out. If not, post what you tried and we will work it out with you.
- Adagio8 years agoFrequent Contributor
Hi Marsha
I'm already working with Excel files using the COM object. This page has nothing related to my query.
I'm trying fund a way to copy and rename a worksheet in a workbook using JavaScript.
Thank you
Abhi