Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: Perl vith VBA macros with arguments

by GrandFather (Saint)
on Oct 11, 2022 at 20:08 UTC ( #11147355=note: print w/replies, xml ) Need Help??

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.

Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond
  • Comment on Re: Perl vith VBA macros with arguments

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11147355]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2023-03-23 17:42 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (60 votes). Check out past polls.