I'm trying to write code that I want to work with any version of Excel, but my problem will apply to any component of Office. To test the Excel end, I have installed two versions of office with more planned. However, I have a strong personal preference for 2002 (XP/10) over any later version. 2003 (11) isn't sufficiently different to matter often except in a few edge cases where I prefer its advantages, but 2007(12) and 2010(14) are right out.

So much for personal preference. But the real point is testing. I want to be able to run Perl against any version of Excel on my machine. Unfortunately, although I can install multiple versions in such a way that the user can choose either, I can see no way of persuading Win32::OLE (a) to use a version of my choosing or (b) to tell me what versions are available. Since this is to check that software works, the second problem is unlikely to be critical. But the first has got me seriously stuck as Win32::OLE always seems to use the highest numbered version. I have Googled unsuccessfully and have tried things like changing Excel.Application to Excel.Application.10, but without success. Advice would be appreciated.

TIA & regards,

John Davies

In reply to Win32::OLE and multiple versions of Office by davies

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.