Hello,
The code I use copies "Blad6" of workbook Names, and replce the page"Blad6" in Workbook "Form_transfertest".
The problem is that the code insert a new page, I want that the old sheet "Blad6" in the workbook Form_transfertest is replaced by the copied one from workbook Names.
The code:
Code
Sub copy()
Workbooks.Open Filename:= _
"[URL="file://\\Post.bpgnet.net\fs\NSCGNT\GENTX\Unit\PLANNING\Planning&Performance_Control\Formtransfer\Form_transfertest.xls"]\Form_transfertest.xls[/URL]"
Application.EnableEvents = False
Windows("Names.xls").Activate
Sheets("Blad6").Select
Sheets("Blad6").copy Before:=Workbooks("Form_transfertest.xls").Sheets("Blad6")
Application.EnableEvents = True
Sheets("Formulier").Select
ActiveWorkbook.Save
ActiveWindow.Close
End Sub
Display More
Greetings
aisietie