PDA

View Full Version : Pivot Chart Macro Problem In Excel



naveenm
09-11-2012, 07:44 AM
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
09-12-2012, 12:00 AM
can anybody reply

mohanvijay
09-12-2012, 12:43 AM
Try this



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



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