Use the macro recorder, create a very basic macro doing only what you want to replicate, convert the macro from VB to perl. How do I convert a VBA macro to Perl?.