Now with this improved macro, I can take on any set of variables, modify a few words, and convert them to the final result. Once he understood the end goal, Brent took my improvements to heart and ran with them. From our first discussion, Brent has always been very understanding and patient with my situation and listened to my suggestions for improving the macro’s speed and efficiency. I contacted Brent to see what could be done with my use case. Out of all the macro videos, the "Excel Find and Replace across Multiple Word Documents" video seemed like it could help automate a seemingly manual process. I found Brent through his YouTube channel: Leverage & Lean ( ). For example, "John 17:21" should be "Joh 17:21." Once the variations are converted, then the next step is to convert them to a markdown language so they can be used in Obsidian. The use case for was to convert all the variations of Bible verse codes (B C:V - Book Chapter:Verse) in any text to a standardized code. In regards to Excel Find and Replace across Multiple Word Documents | VBA Macro #30 and custom work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |