Macro Mondays – A Simple Macro To Refresh All Data Connections When Opening An Excel Workbook
Happy Monday!, and it is Macro Time. Welcome to another #MacroMonday #Excel blog posts in my 2020 series. Today we will write a simple macro to refresh all data connections when your Excel...
Count The Number Of Times A Workbook Has Been Opened. Macro Solution.
Hello Excellers, welcome back to another #Excel #MacroMonday blog post in my 2020 all things Macro series. Do you need to know how many times a workbook has been opened?. Would you like to know...
Welcome back Excellers to another #MacroMonday blog post in my #Excel 2020 series. Today let's write an Excel VBA macro to count files in a folder. I have used this macro regularly when I am...
Hello Excellers and welcome to another Excel #Excel tips #MacroMonday bog post in my 2020 macro series. Today I want to share with you a simple macro. This small bit of code will clear all cells with...
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. Do you want to quickly create a backup of your Excel workbook in the same folder as your original...
Hello Excellers and welcome back to another #MacroMonday #ExcelVBA blog post in my 2020 series. Have you ever needed to convert a whole folder of Excel files into CSV files? Me too!. Just last...