![]() |
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