I have had to rebuild my OS10 system and reinstall Office including Excel. I no longer can use Excel with Perl applciations.
The test Perl which shows this is new. 
use strict "vars";
use Win32;
use OLE;
use Win32::OLE::Const "Microsoft Excel";
my ($excel, $workbook, $sheet);

$excel = CreateObject OLE "Excel.Application";
print "excel <$excel>\n";

$excel -> {Visible} = 1;

$workbook = $excel    -> Workbooks -> Add;
print "workbook <$workbook>\n";

$sheet    = $workbook -> Worksheets("Sheet1");
$sheet                -> Activate;
print "sheet <$sheet>\n";

[download]
On a PC where this is working I get the following from the print

excel <OLE=HASH(0x27415ae1b90)>
workbook <OLE=HASH(0x27415d78a70)>
sheet <OLE=HASH(0x27415d78908)>

On the failing PC I simply get

excel <>
Can't call method "Workbooks" on unblessed reference at D:\radan-docs\radan-f\perlwork\programs\excel-test-1.pz line 16.

This is the $workbook line which is not surprising as the $excel line failed.
I guess that there is some problem with the line getting access to Win32::OLE for Excel.
I have re-installed Office but that did not help.
I did wonder if it might be to do with the places looked by the @INC array but 
 print "dollar inc @INC\n";

[download]
gave the same list for both PCS.
I have done this before and had no problems.
Can any Monk suggest ways I can cure this?

In reply to Using Excel in Perl failure after OS re-install by merrymonk

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.