My current and only regex activities are related to Excel and VBA. As I learn more about Regex I miss in VBScript Regular Expression 5.5 a lot of the advanced regex functionality like "mode turning on and off within the regex like (?ism) and (?-ism)" - for i.e. to search "case-insensitive" and replace "case-sensitive".
Q1: Is it possible to use an other regex flavor in Excel for example ".net framework regex" and if so how do I have to accomplish that.
Q2: Am I right, that Office 2007 and 2010 do not provide more regex support?
Q3: Other solutions?
I did not find any clear answers up to now in the Web and the EE knowledge-base except something in that direction on
but I am not familiar with Visual Studio.
I also found articles about how to use the Excel classes in .net applications but not the contrary.
Thank you for any help