Hi NetWallah,

Fantastic, that does the job!! Now I'm about to start googling the use of 'in' that you've used here to find out how it works.

One thing that I really didn't expect, is just how much it has slowed my script down. I did think it would to some extent, but it's actually gone from a total run time of 8 minutes to 36 minutes (yes I've got quite a few tables being joined). No, my PC is a fully up to date desktop running a quad core i5 - I only built it earlier this year, so it is the OLE that is slow. By comparison, the old script took 1 hour to run on my little netbook, I guess I wont be using it on this new script!

I will be investigating better ways to issue some of the reports - maybe write them to excel and then output as PDF instead of word tables, that will improve things dramatically. But my renewal letters need to stay in Word and use this new script.

Many thanks again oh wise one!

In reply to Re^2: MS-Word OLE and Joining Tables by BrianP6
in thread MS-Word OLE and Joining Tables by BrianP6

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.