in reply to Use Win32::OLE to run vba subroutine in MS Access

You don't tell us how they fail for you. A common approach to automating all Office applications is to record the sequence of commands as a VBA macro and then converting that macro to Perl. Hence, start recording a macro, then press ALT+F8 or whatever the "Run Macro" hotkey is, run the macro, press "Stop Recording". Then press ALT+F11 and inspect the generated code for your macro.