Open Workbook & Copy To It

I am trying to write a piece of vb code that opens a workbook and enters some data into it, saves it as a different file name and closes it.

Basically, I have a worksheet with two sheets. One is a list of a few values (order number, description, date), the other has three cells which the user enters the values into, and a command button. When pressed it transfers the data into the table on the first sheet.

I then need it to open a workbook C:/ewr.xls and put these values into this, rename it as ewr180.xls, (where 180 is the order number) and save it

I'm almost there but just cant seem to get the values into it

I know i must be missing something so simple, any help would be much appreciated.

Private Sub createEWR_Click()
Dim ewnnum As Integer
Dim descr As String
Dim ewndate As String

' enter new row with data