If you plan to use Win32::OLE to interact with Microsoft applications often - I have found ActiveState's VBScriptConverter which ships with their PDK Productivity Tools to be very helpful. This program will convert VB Macros directly to Perl code.

Another useful tip: After recording a Macro in Excel - press Alt+F11. This will open up Visual Basic where you will be able to view and edit the VBScript generated when you recorded the Macro. You can then convert this to perl yourself using the rules in the Win32::OLE documentation - or paste it into the VBScriptConverter and let it do the work.

From within Visual Basic - you can also press F2 (or select View->Object Browser) to bring up the object browser. Here you can view the different attributes and methods of the different objects you can interact with.

I find that when you are unsure of how to do something, this is the easiest way to figure it out is to record the Macro and then look at the VBScript that was generated. This is usually much easier and quicker than piling through documentation.

In reply to Re: coding for excel in perl by jeffreyray
in thread coding for excel in perl by ruxer

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.