"Rob" <rmfoley@mchsi.com> wrote...
....
>The easiest way I know to grab the information I need is using Regular
>Expressions to parse through each line of the report.
....
>I really would like to write the code using VBA because I'm starting to
>feel comfortable with the language and I've created about a dozen routines
>that I use in Word/Excel/PowerPoint. I'd like to continue becoming more
>proficient.
....
VBA itself doesn't have regular expressions, but since you mention C#, it's
a fair bet you're using Excel under Windows. If so, you almost certainly
have Windows Script Host installed, in which case you could use
VBScript/VJScript regular expressions.
The documentation is available online from MSDN. They used to have it in a
downloadable form, but who knows whether that's still available.
As for how to use it, see
http://groups-beta.google.com/group/...c5c9457939edb5
Bookmarks