Copying a worksheet from another file into my active worksheet

[chadski778]

I would like code for copying a worksheet from another open file (Sheet1.Calculations For HSE dossiers.xls) and adding it to the active workbook as a new tab

Is that possible?

 

[VoG]

Try

Workbooks("HSE dossiers.xls").Sheets(1).Copy after:=ActiveWorkbook(Sheets(Sheets.Count))

 

[chadski778]

It isn't working it is saying 'object doesn't support this property or method'

 

[VoG]

Oops!

Workbooks("HSE dossiers.xls").Sheets(1).Copy after:=ActiveWorkbook.Sheets(Sheets.Count)

 

[chadski778]

That's brilliant thank you very much