Macro & VB help

[caulifllower]

I need help on edititing a macro code in vb excel. I need to insert or copy a sheet to an existing workbook and i'm not sure how to go about writing the code. Can any help me out here.....

 

[SteveO59L]

Try using the macro recorder to insert a sheet, then look at the code produced.

 

[caulifllower]

Here is my macro recorded code below. However, when i rename the testing workbook this code would come up as a error. I need a code that would still do the same after i rename the workbook. Can anybody help?

Sub Button1_Click()
Workbooks.Open Filename:= _
"C:\Tracking.xlsx"
Sheets("Tracking").Select
Sheets("Tracking").Copy Before:=Workbooks("Testing.xlsx").Sheets(1)
Windows("Tracking.xlsx").Activate
ActiveWindow.Close
End Sub