Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Win32::OLE Excel Perl Documentation

by davies (Vicar)
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.

Regards,

John Davies


Comment on Re: Win32::OLE Excel Perl Documentation
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (10)
As of 2014-12-25 23:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (163 votes), past polls