Thanks. I will play with that idea some. It appears that I may be able to use Win32::OLE->LastError in some way to facilitate this also.

Another thing I want to experiment with is the possibility that the errors that cause the Perl script to terminate may be doing so via a signal of some sort. I plan to experiment with that to see if that is the case and I may be able to avoid termination of the script by trapping the signal, if there is one. In the meantime, I posted a new snippet of code to one of my other nodes which bypassed the errors for that specific case without solving the general problem.

WRT my choice of username, this goes back to my years as a systems programmer with mainframes. At my employer's site every user had a three-character userid which was normally his/her initials. If somebody else already had the same initials the middle initial was changed to something else like x or z. When we galumphed into the Unix world we had more freedom and many users expanded their userids to something longer but I never did. So for the 33+ years I worked there I was known by those initials and it is just natural to try selecting that first as a userid on a new site.

In reply to Re: Checking when Excel editing is done by esr
in thread Checking when Excel editing is done by esr

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.