VBA regular expression introduction & examples

I made three function that uses regular expression to extra data, replace data, and to get data counts

[ericturner]

Hey! Very informative video. Question, since your function regex_get_matches is already a collection why do you need to 1) create a “Matches” variable in which to store the expressions, then 2) take each matched string and store it in the “item” variable, then 3) place those “items” in the “container” collection and then 4) pass the contents of that “container” variable back to regex_get_matches as the function result? Couldn’t you just “Set regex_get_matches = regex.Execute(data)”? All of the strings would be stored in the collection as the function result. Any downside?

[rakeshkumarmadella]

Sir size of the scrèen is very small.. not able to see anything.. please in crease font size of your code.. thank u

[minalramteke]

Hi Sir,
last time you helped me and was worked and thank you so much for that ....now again i am stucked in vba code is my code is connected with ppt. I have sample ppt which is connected with thinkcell. In some slides i have table and in that table i just want to paste data from excel(note : i dont want to replace the am able to copy and paste table but dont want to paste table i just want to paste data into existing ppt will be really helpful if you can help me you in advance