I am no refence work on this project , pls advice details info how can work
out

"Joel" wrote in message
...
Sub makebooks()


Set FrontEnd = Workbooks.Add(template:=xlWBATWorksheet)
Set FrontEndSht = FrontEnd.Sheets(1)

'create copy of worksheet in new workbook by using copy without before or
after
FrontEndSht.Copy
Set Newbk = ActiveWorkbook

Newbk.SaveAs Filename:="c:\temp\bookx.xls"

End Sub


"IT" wrote:

I want create two Excel file, one for fontend only for user type in data
,
after press save button in this form. The record can save data to backend
excel file for record. because i want protect backend file modify by
user.
Please advice how can do that