I can tell from your posts here that you are experienced enough to know this, so for the benefit of other readers I'll just mention that sometimes the smartest approach is to burn the entire edifice to the ground, let its ashes be dispersed by the four winds and start afresh.

That is exactly our intention (no refactoring in VBA), but the mathematics hidden in the Excel files has to be reproduced exactly.

Some background (as much as I can tell without risking a lot of trouble): Measurement results from several days of running a device on a test rig under varying conditions are written to CSV files, then read into the first Excel file, processed, saved, passed along to next N Excel files, and finally results in a set of calibration parameters that will be written back to the device. The various Excel files could generates a lot of printouts that are already disabled in the code, because nobody cares. But whatever replacement we will build, it must generate exactly the same calibration parameters given the same measurement results. It must be bug-compatible with whatever happens in the Excel files.

And, you may have guessed it: The entire mess is strictly confidential. I can't show the VBA code, I can't explain more details.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

In reply to Re^2: [OT] Finding similar program code by afoken
in thread [OT] Finding similar program code by afoken

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.