Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: Where is the Win32::OLE Docs

by davies (Prior)
on Oct 08, 2009 at 23:06 UTC ( #800117=note: print w/replies, xml ) Need Help??

in reply to Where is the Win32::OLE Docs

I'm writing something to hack Excel (I can't help specifically with Word), and one of the techniques I have found useful is to write a VBA prototype. That way, you can work out the VBA references using intellisense, which typically gives you all the available options. Then it's relatively simple to rewrite the Messware code in Perl. The one thing I can't help you on is why and when {braces} are needed. The only Excel use I have found is in $app->{Visible} = 1. Watch out, though, for case. Perl is case sensitive while VBA isn't - it will convert case for you, and whatever it gives you is what you should use.


John Davies

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2019-09-17 00:23 GMT
Find Nodes?
    Voting Booth?
    The room is dark, and your next move is ...

    Results (199 votes). Check out past polls.