in reply to Perl vith VBA macros with arguments
The starting point is Win32::OLE, but it's quite a few years since I did that sort of stuff and I'd need to refresh my memory outside work hours. If you don't get a detailed answer by this evening (my time) I'll have a dig around for some old code and see what I can find.
If you are dealing with Excel you may find Win32::ExcelSimple helpful, although I've not used it and don't know its capabilities. Its documentation is essentially completely missing and suggests you read the test files to figure out how to use it.