Today we will discuss different ways to check if a file exists in Excel-VBA.
Excel and Excel-VBA Built-In and Custom Tools for Productivity
This custom function generates triangular distribution with a specified minimum, maximum and mean.
Sometimes we have a task to go through a number of files and make some changes in each of them or pull data from them. In this article we will have a look at the Excel-VBA code which allows to do all of that.
Excel-VBA script for running simple Monte-Carlo simulations in Excel (no add-ins required).
All you need to know to get rid of 80% of your routine and focus on more interesting tasks
In the first part we will discuss instruments, which I wish I have known how to use when I have started my first job as a Budget Analyst. They would have allowed me to automate 80% of the routine and save hundreds of hours of time.