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.