Thanks for your reply. I tried it and I think it would be the easiest way to go. One can easily translate the basic VB code to Perl. Problem will be converting those that are a little complicated. Have you tried using the Perl Dev Kit on this?
Comment on Re^4: How to create pivot tables via perl?
Why would I want to try the Perl Dev Kit with this? As you don't show us which parts you have problems translating from VB to Perl it'll be hard for us to help you there. As a point of reference, I found no problems in automating the creation of a pivot table and pivot chart in Excel.