in reply to need advise on how to tackle an automation program using perl.

Writing Excel file is "easiest" done using Excel::Writer::XLSX.

If you want to talk to the Office programs, there is little difference between doing that from Perl or doing that from within VBA, but VBA has the far superior IDE with autocompletion for doing OLE. Personally, I recommend using the macro recorder to record a VBA script that does most of your task and then rewriting the VBA either in Perl or Visual Basic to do all of your task. The macro recorder removes much of the need to learn the Office API before you start. See also Using Win32::OLE and Excel - Tips and Tricks, which applies to most of the Office Suite not only Excel.

  • Comment on Re: need advise on how to tackle an automation program using perl.

Replies are listed 'Best First'.
Re^2: need advise on how to tackle an automation program using perl.
by perlynewby (Scribe) on Oct 26, 2015 at 22:34 UTC

    I am now learning Visual Basic app scripting; this looks cool but will take me sometime to get there...

    rewriting the VBA either in Perl

    I wanted to continue to build experience in Perl and your comment seems to lead me to believe that I can write my little automation in VBA then re-write/tranlate this VBA code into Perl, right? I don't know how so I will do VBA then hit the monks to help me translate into perl.

    I've created some easy quick Modules(2 so far) in perl and will like to continue to learn more.

    any ideas on a quick automation ideas using modules and perhaps some GUI (want to learn how to build gui with automation)

[reply]

In Section Seekers of Perl Wisdom