Copy an Excel worksheet to another workbook 1

[jers]

Hi, I'm trying to copy an Excel worksheet to another workbook using a vbscript. What is the correct syntax for VBA's After:= in vbscript (so it doesn't expect the end of a statement here)?
Thanks, jers

xlapp.Worksheets("Buy List").Copy [b]After:=[/b]Workbooks("Print List.XLS").Worksheets(1)

 

[PHV]

xlapp.Worksheets("Buy List").Copy , xlapp.Workbooks("Print List.XLS").Worksheets(1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886