Basically, (as mentioned in another response) the docs that will get you anywhere are found on the Microsoft Developer Network. These are all geared toward Visual Basic, but you just need to translate them into perl (arrows instead of dots, for instance).

One gotcha occurs when you want to assign a value to a property. To get a proper lvalue for assignment, you need to enclose the property name in braces: 

$sheet->Cells(3,3)->Font->{Bold}=1

[download]
would be an example in Excel.

In reply to Re: Can I use Win32::OLE to insert a TIFF in a Word document? by mpolo
in thread Can I use Win32::OLE to insert a TIFF in a Word document? by bloodelf2

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.