Copy Worksheet (from another workbook) to an Active Workbook

Hi All,

I am trying to create a VB code that can copy a specific tab from a specifc file to the active file that is opened.

Sub CopyWB()

Dim curWorkbook As Workbook

Set curWorkbook = ActiveWorkbook.Name
Workbooks.Open Filename:= "C:\QA.xlsx"      'Copy "QA" tab from "QA.xlsx to the active open file
Sheets("QA").Move Before:=curWorkbook.Sheets(1)

End Sub

However, it gives me an error when referencing to the active book. Any helps is greatly appreciated.

Thanks...