How to implement trial period or protection for your Excel Add-ins or workbooks using Excel VBA

There might be¬†situations when you would like to set a trial period for your Excel applications: maybe you want to prevent employees take the applications and use them forever in other places after they leave your company or you simply need to provide to a client a trial that can be tested only a limited…

An example of how to use Excel VBA Dictionary of arrays data structure

In this post I will demonstrate how to use¬†Dictionaries in Excel VBA in order to calculate, store and use data¬†summarized¬†on different criteria. In the real life I used the algorithm from this post to automate the issue of inter-company invoices. This automation saved dozens of hours considering that before they had it, users where issuing…

Excel Formula and VBA solution to dynamically extract the file name from website paths

You have an Excel file with thousands of rows like in the below image and for each row you need to extract the file name: How would you do this ? Solution: One formula that can solve your¬†problem is this one: =RIGHT(A3,LEN(A3)-FIND(“$”,SUBSTITUTE(A3,”/”,”$”,LEN(A3)-LEN(SUBSTITUTE(A3,”/”,””))))) Let’s explain how it works:¬† The file name is the sub-string after the…