ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add New Worksheet through VBS COM Object (https://www.excelbanter.com/excel-worksheet-functions/108808-add-new-worksheet-through-vbs-com-object.html)

jgreer9514

Add New Worksheet through VBS COM Object
 
I have a problem when I try to add a worksheet through the EXCEL COM object
it adds Sheet4 in front of Sheet1, Sheet2, Sheet3. I want it to add the
sheet at the end of the sheets. The following code does not work from a .vbs
external script.
Excel Code:
ActiveWorkBook.Sheets.Add after:Worksheets(Worksheets.Count)

I have tried externally:
ExcelApp.WB.Sheets.Add (after:=Sheet3)

What to put in statement after Add?


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com