search

tallguyjenks / Obsidian-For-Business

Using Obsidian.... For Business!
https://www.bryanjenks.dev/
MIT License
149 stars 12 forks source link

VBA compile error: user-defined type not defined..."New RegExp" #22

Closed mashean closed 2 years ago

mashean commented 2 years ago

Hi - newbie here and very interested in using this tool but unfortunately can't get it to work with my outlook...

when I try to run the ExtractEmail macro, the application errors when it gets to the Function formatName function and gives me the VBA compile error as the New RegExp variable is not defined...

Looks like it's the SaveUtilities module. Followed the instructions on how to install / double checked source to target and everything seems to check out yet getting a compile error

this is where the compile error is happening:

Dim regexJustFirstNameAndLastName As Object Set regexJustFirstNameAndLastName = New RegExp regexJustFirstNameAndLastName.Pattern = "^\w+\s\w+$" If regexJustFirstNameAndLastName.Test(str) = True Then typeOfNameToClean = 1 Set regexJustFirstNameAndLastName = Nothing

Appreciate any help you can provide. Thank you.

github-actions[bot] commented 2 years ago

This was your first issue! Thank you for contributing!' first issue

tallguyjenks commented 2 years ago

and you completed step 4?

mashean commented 2 years ago

and you completed step 4?

Hi Bryan! thank you sir...feeling dumb right now :)

It's working now. Really love the concept and hugely helpful for someone who lives on Outlook and Obsidian. Thank you!!!

tallguyjenks commented 2 years ago

glad it was something simple! Enjoy :)