Super Search is your friend here on PM... For example, the right combination of keywords might have led you to the following nodes, where:

marto has some excellent advice for converting VBA to Perl; I show how to find information on object models and MS constants; and holli has good advice on how to get the MS Office program's macro recorder to do most of your work for you...

HTH,