Splitting out to .csv files is a good idea, but it does have some issues.  First, a .csv can only save out one sheet at a time; manually saving out 200+ sheets would be mind-numbingly painful (hopefully VB would/should be able to automate this task).  Second, the resulting 200+ files are coming close to the maximum number of open file handles a 32 bit Perl can handle (depending on how many derivative files are created it could be uncomfortably close).  The number of file handles becomes an issue because it sounds like the OP is doing some massive cross-referencing between sheets (meaning most, if not all, of the .csv files would need to be open).  Seconding a previous post, this file should have been entered into a database long ago...

In reply to Re^2: Waiting ... by northwind
in thread Waiting ... by PerlingTheUK

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.