Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I've been racking my brain and searching for references to figure out how to copy and excel work sheet with in a single work book to use as a template with in that same work book. The only thing I can find is VBA code, I'm doing an administration script in VBS and can't figure out how to convert it. According to Microsoft's reference the VBA command is: Worksheets("Sheet1").Copy after := Worksheets("Sheet3") I've got the VBS code below. Set objExcel = WScript.CreateObject("EXCEL.application") objExcel.Visible = True objExcel.Workbooks.Add objExcel.Worksheets.Add.Name ="USERSLIST" This part of it objExcel.Worksheets("Sheet1").Copy will copy the worksheet but to a new workbook. 8/ Any help at all on this would be greatly appreciated. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to copy print set up to other excel worksheets? | Setting up and Configuration of Excel | |||
How do I copy text using a formula between worksheets in Excel? | Excel Worksheet Functions | |||
How do I automatically copy columns to/from Excel worksheets? | Excel Discussion (Misc queries) | |||
Copy Excel worksheets | Excel Discussion (Misc queries) | |||
In Excel, can I copy Headers and Footers between Worksheets? | Excel Worksheet Functions |