Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Win32::OLE Excel Perl Documentation

by davies (Parson)
on May 08, 2013 at 21:55 UTC ( #1032685=note: print w/replies, xml ) Need Help??

in reply to Win32::OLE Excel Perl Documentation

There isn't one that I've met. There might even be legal issues (IANAL) about producing one, as it may be MS copyright in some jurisdictions. The generally recommended approach is to understand what you want to do in terms of VBA (recording a macro is often suggested, but that tends to be bad VBA) and then translate it to Perl. If you can give some concrete examples of what it is you are trying to do, I and the other monks may be able to give you pointers to some of the specifics, but automating Excel does mean understanding Excel, and that is generally easier if you attempt to do it on Excel's own terms.


John Davies

  • Comment on Re: Win32::OLE Excel Perl Documentation

Replies are listed 'Best First'.
Re^2: Win32::OLE Excel Perl Documentation
by suzun30 (Acolyte) on May 08, 2013 at 22:37 UTC

    Thanks for the prompt reply. I am right now going by trial and error on the vba obect tree model and replacing the .s with ->s and so far accomplished what I needed, by googling and surviving with solutions from other peoples issues posted on forums. Would have been easier to have a handbook to refer to. I will post with my issues once they are out of scope. Appreciate the inputs.

    Thanks again!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1032685]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (4)
As of 2018-05-21 04:00 GMT
Find Nodes?
    Voting Booth?