R
Ron Rosenfeld
If I read your results correctly, it would seem for a macro executing wholly
within the VBA world, using the regular expression scripting engine is
slower than using native, built-in VBA functions; however, once your macro
interacts with the spreadsheet world, any coding time differences get buried
by the time required for VBA to communicate with the spreadsheet.
Rick
That would be my conclusion, also.
It does give rise to some coding considerations (i.e. keep as much of the
scripting engine outside of the read/write loops as possible), but that just
makes common sense, anyway.
--ron