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

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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2016-05-28 02:29 GMT
Find Nodes?
    Voting Booth?