I'm guessing a bit here, so don't be surprised if I get this wrong. I think it's to do with the doubled backslashes in your file name. Because you are using single quotes, escaping doesn't happen and the literal string is used as the path. Since Losedows can't support unnamed directories (between the pairs of backslashes), it can't find your file. Because you have specified the 'Quit' option when you create the Excel instance, this closes Excel when the code exits. This happens when you open or die. Try (a) single backslashes or double quotes, (b) removing the "quit" option, (c) not dying. If none of these work (or give you the clues to getting it to work), please tell us what happened.

Regards,

John Davies

In reply to Re: Open an excel file using win32::ole module by davies
in thread Open an excel file using win32::ole module by bks

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.