Regular Expressions: Named groups in VBA

[Medwar19]

Hi,

Is it possible to used named groups in VBAs version of Regular Expressions (Regexp)

Example match groups for extracting dates from strings:

(?:(\d{2})\.(\d {2})\.(\d{4})\s (\d{2}):(\d{2}) :(\d{2}))|(?:(\ d{4})-(\d{2})-(\d{2})\s(\d{2} ):(\d{2})

will returns DD.MM.YYYY or YYYY-MM-DD in submatch groups but the ordering is mixed up depending on the formatting.

A better solution would be:

(?:(?<Day>\d{2} )\.(?<Mon>\d{2} )\.(?<Yr>\d{4}) \s(?<hh>\d{2}): (?<mm>\d{2}):(? <ss>\d{2}))|(?: (?<Yr>\d{4})-(?<Mon>\d{2})-(?<Day>\d{2})\s (?<hh>\d{2}):(? <mm>\d{2}):(?<s s>\d{2}))

Which names the groups using the <name> method.

These strings work fine in VB.net but not in VBA???

Thanks,

Mark