[VBScript and Excel] Moving a sheet to the end of the list

Here's how to put the first sheet in a new spreadsheet at the end. This is a copy of a recent submission of mine at Automate Excel In Vbscript... ( Vbscript ) Set oExcel = CreateObject("Excel.Application") Set oWorkBook = oExcel.Workbooks.Add oWorkbook.Sheets("Sheet1").Move ,oWorkbook.Sheets( oWorkbook.Sheets.Count ) Note the comma after the space that is after the .Move. I'm specfying the "after" clause rather than the "before" and saying to move the sheet to after the last.

BTW, one of the best ways of finding out syntax is to record a macro and adapt the resulting code.