Hi, I am a newbie to Perl. I am struggling a bit to read the contents of Macro Enabled Excel. The Excel sheet has buttons, which define the name of the component. Next to that cell.. the price of the component is defined. When we click on the button it takes me to the page where the complete details of the component is mentioned. All I need, is to read the first page ... i.e., the button (Name of the component) and its corresponding price... and display it on the terminal.. I have written a code using for loops... where I increment the rows & columns... As there are buttons existing in the excel.. I am unable to print the component name... But I could print the price of it... Please let me know .. how to get the component on to the screen.. Bye,

In reply to Re^3: Win32::OLE: how to call Excel VBA macros and catch all VBA errors without dialog boxes appearing? by srinath_vlsi

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.