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.
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.