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}):(?<ss>\d{ 2}))

Which names the groups using the <name> method.

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

Thanks,

Mark