Creat Pivot Table with a Macro

I want to create a pivot table with a macro (using record macro and then create a pivot table) along with a button to run next time for different data. but after stoping when I am trying to run the macro I am getting this error

    ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
        "'Sheet2 (2)'!C1:C2").CreatePivotTable TableDestination:= _
        "'[GE.xls]Sheet2 (2)'!R1C4", TableName:="PivotTable1", _
        DefaultVersion:=xlPivotTableVersion10

If some one can help me in this regard would be appreciated.
I want to clear that I don't know much about VB. Pls. Help

Rana