I'm not sure what your question is. Are you having trouble saving the file as a different name, or copying the new data into the sheet?

>I am pushing data into a formatted Excel file. Before I push the data into the workbook I am trying to save the workbook as a new file(create a duplicate of the original for the user to modify) and then open it and push the data in it.
>Can someone please point me in the right direction.
>
>loExcel = CREATEOBJECT("EXCEL.Application")
>WITH loExcel
> .Application.Workbooks.OPEN("my path to the template")
> .Application.Save("my path to the new file")
> .ActiveWindow.CLOSE()
> .Application.Workbooks.OPEN("my path to the newfile")
> .Application.Worksheets("sheet1")
>
> *push all the data in
>ENDWITH
>
>-Wes