Macros

Insider

Insider Benefits

If you are looking for more from Leverage & Lean you have come to the right place!

Comment on Macros

As an Insider your voice will be heard! Insiders are given the rights to comment on any Leverage & Lean macro. Comments allow you to request improvements to macros to meet your unique needs. In addition others Insiders will see your comments and have the opportunity to give a thumbs up or weigh in with their thoughts. Comments will help start the conversation around how macros can be improved and how we can help each other achieve Less Clicks, More Results!

Insider Content

As an Insider you will gain access to hidden content! This can include additional code that will help you better manage implementing Leverage & Lean macros! Our Insider Content is designed to keep you away from updating code and focus on acheiving Less Click, More Results!

Count Macro Usage

Macros are a great time saver because they can automate repetitive tasks at work. The Macro Count macro was developed to better understand the potential time savings gained from running macros. As an Insider you will gain the ability to count your macro usage and analyze how much timing savings is gained. At Leverage & Lean we know how critical measurement is to your success!
Learn more about the Macro Count macro here!

Request Custom Macros

Can’t find what you are looking for in the Leverage & Lean macro library? As an Insider you can request a completely custom macro to meet your specific needs. Subscribe today and lets build something powerful together! Request a custom macro now!

Insider Priority

At Leverage & Lean Insiders come first. If you reach out to us subscribed as an Insider you can expect an increased priority to answer your questions and provide you what you need!

Guidance & Support

Leverage & Lean exists to take pain out of computer processes. Tell us your struggles. We will help anyway we can!

Influence Content

Insiders are the most important part of Leverage & Lean. Your feedback will impact the direction of future content.

Subscribe as an Insider today!

Already a Leverage & Lean Insider? Login here!

Annually

(Access all Insider Macros)
$ 120
00 Per Year
  •  
Subscribe
Shop Insider Macros
Click to explore individual Insider Macros for purchase.

Need a custom macro?

Let me build one for you!

Here are my current rates for this year.
$50.00/hour (Programming)
$75.00/hour (Meetings)
FREE hours quote, invoicing through PayPay at desired frequency.
Get Started Here!

Need a custom macro?

Let me build one for you!

Here are my current rates for this year.
$50.00/hour (Programming)
$75.00/hour (Meetings)
FREE hours quote, invoicing through PayPay at desired frequency.
Get Started Here!

Like . Follow . Subscribe . Connect

Facebook Twitter Instagram Linkedin Youtube Github

Contact Us

Looking to improve your computer processes?
Leverage & Lean is here to help!

Stay Awesome!

Leverage & Lean

Is focused on improving computer processes by Leveraging programming and applying Lean principles. It is our goal to make you more efficient and effective on your computer producing “Less Clicks and More Results!”

Get Started

Macros

Lean

YouTube

Copyright © 2019 Leverage & Lean
Facebook-f Twitter Linkedin-in Instagram Youtube Github
Powered By MemberPress WooCommerce Plus Integration

In regards to Word Create Outlook Email with Selected Text | VBA Macro #29

This is so perfect!
Thank you so much!

At my job, we recently switched over to Office 365. Previously we had an email template that we could fill out (using field codes [select all+F9]) but that is no longer available in Office 365, as only Word has the Field Code capability now.

I was trying to find some sort of solution using Word, and yours was the best thing I could find on the web!

Very straightforward!
Very appreciated!
YOU are the awesome one!

Allen

In regards to Excel Find and Replace across Multiple Word Documents | VBA Macro #30 and custom work.

The use case for CheckTheBible.com was to convert all the variations of Bible verse codes (B C:V - Book Chapter:Verse) in any text to a standardized code. 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.

I found Brent through his YouTube channel: Leverage & Lean (https://www.youtube.com/LeverageLean). 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 contacted Brent to see what could be done with my use case. 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.

Once he understood the end goal, Brent took my improvements to heart and ran with them. Now with this improved macro, I can take on any set of variables, modify a few words, and convert them to the final result. This custom macro searches Word Documents for Bible verse codes, uses a standardized list of 30+ thousand B C:V codes to convert to the markdown language automatically with 100% accuracy.

I have had a great experience working with Brent. Not only does he clarify expectations so it was set up for success, but most importantly, he has always come up with creative and comprehensive suggestions even outside the scope of macro building. Brent was really consulting me to do more than what I had thought possible.
Edward