E
Erik Creyghton
I have some large Excel models running using pivot objects controlled
through VBA. The models are developped using Excel-97. We now are rolling
out new desktops with Office-2003. The change over from Excel-97 to
Excel-2003 will take about 2 years. I will have to support mixed Excel
environments on my models.
What is the best way to solve this problem. I do understand that the version
property is available on the application object. I do not see how this will
solve the issue of the pivot cashes which reside inside the workbook.
Any help or links appriciated
Erik
through VBA. The models are developped using Excel-97. We now are rolling
out new desktops with Office-2003. The change over from Excel-97 to
Excel-2003 will take about 2 years. I will have to support mixed Excel
environments on my models.
What is the best way to solve this problem. I do understand that the version
property is available on the application object. I do not see how this will
solve the issue of the pivot cashes which reside inside the workbook.
Any help or links appriciated
Erik