View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_13_] Mark[_13_] is offline
external usenet poster
 
Posts: 1
Default Excel Worksheets.Copy in VBS???

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