Copy specific data from an excel template and paste in new workbook

[Excel Fox]

Can you check that the information in the two templates are not exactly the same?

EDIT: And add a back-slash for the path you specified

"C:\Test\"

[excel_1317]

I had changed the template name, cell E5 and cell D20..

Can you check that the information in the two templates are not exactly the same?

EDIT: And add a back-slash for the path you specified

"C:\Test\"

[Admin]

And add a back-slash for the path you specified

"C:\Test\"

That's already been taken care of in the code itself

replace

.Range("a2").Resize(n) = k

with

.Range("a2").Resize(n) = Application.Transpose(k)