in reply to OLE & Excel

Try use strict;

Visual Basic syntax does not work very well in perl.

Use Spreadsheet::ParseExcel to make data entry and formatting easier.

Replies are listed 'Best First'.
Re: Re: OLE & Excel
by tbone1 (Monsignor) on Mar 11, 2004 at 13:24 UTC
    Also sprach NetWallah: Visual Basic syntax does not work very well in perl.

    I know that this is off-topic, but I haven't been too impressed with how it works in VB, either.

    --
    tbone1, YAPS (Yet Another Perl Schlub)
    And remember, if he succeeds, so what.
    - Chick McGee

[reply]
Re: Re: OLE & Excel
by Saadat_saeed (Initiate) on Mar 11, 2004 at 06:24 UTC
    But it should work.... I am just using OLE and sticking to it..... Any better way to re-write it so that the OLE syntax works and works good!
[reply]

      Don't waste our time and do what NetWallah suggested, add one line to your script, use strict;. After that, fix all errors that strict.pm uncovers in your script. Then your script will work better.

      A small hint: While Perl works with OLE, Perl does not know about a with statement.

[reply]
        I used "use strict" and "use Win32::OLE qw(in with);" so that perl can use the with statement........ still I receive no errors!!!
[reply]

In Section Seekers of Perl Wisdom