Pivot Chart Macro Problem In Excel

[naveenm]

Hi dears,

I stuck in VBA code issue, where i am not able to run my VBA code on other workbooks.

Please find Zip file which has 2 Excel files ,Format.xls & Testpurpose.xls

Format.xls is my personal File where i have stored all macros to run on other workbooks.


Please open Testpurpose.xls and run Macro Format_columns, it is working fine,

after that run Macro Pivot_chart, here is the problem, i am not able to get the pivot table of existing workbook.
it is always creating pivot table taking values of my personal file.

[naveenm]

can anybody reply

[mohanvijay]

Try this

[vba]

Set objTable = ActiveWorkbook.Sheets("Sheet1").PivotTableWizard

[/vba]

why don't you place the all the macros in "Test Purpose.xls"?