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

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

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

I assume you backend file is some sort of database. Could be either Excel or
Access. I need some additional information about the sizes and organition of
Frontend and backend files.

1) Is the Front end going to be a custom userform or just a worksheets with
cells to be that will be modified?

2) Is the orgainization of the Front end and Backend the same (so I can just
copy the data from one sheet to another) or do you want the order put into
the backend into different cell locations?

3) Are yo going to put each submission from the front end to the rear end
into a different sheet in the rearend or is each submission going to go into
the next available row in the backend?

4) Can you specify the sheet names you are going to use in the Frontend and
Rearend

5) Can you specify the column names in the Frontend and Rearend?

6) Do you want the rear end to be Access or Excel? If you are going to ahve
multiple people submitting simultaneously it is recommended that you use
Access for the Rearend.

"IT" wrote:

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