copy file exceltemplate to MyNewLocation loExcel = CREATEOBJECT("EXCEL.Application") WITH loExcel .Application.Workbooks.OPEN("MyNewLocation") .Application.Worksheets("sheet1") *push all the data in ENDWITH