Copy worksheet between workbooks

[kckay]

I am trying to add a sheet from another workbook to the end of my active workbook using this line of code:

Workbooks("c:\New Inspection Stuff\San Survey Blank Template.xltm").Sheets("System Overview").Copy _
After:=ActiveWorkbook.Sheets(Worksheets.Count)

It is not working.

What am I overlooking?

Thanks.
<!-- / message -->

 

[kckay]

Wow! Thanks a ton! Will improve performance massively. Way impressive bit of code.

I was working towards using a sledgehammer. This is much more elegant and flexible.

Thank you.