A couple of weeks ago I published a length post detailing the techniques I have developed to successfully export Excel data to Power BI. I have had some interesting responses and I have since evolved my thinking on this, and my… 1,338 more words
Tags » Vba
Here are 3 VBA functions that I always have in the VBA projects I built.
- Count occurrence of substring in string
This function allows you to count the occurrence of substring in string, various type of data can be passed to the function and case-sensitivity can be adjusted. 257 more words
In VBA, you can save/read data as/from binary file. This is particularly useful when you want to backup any intermedia data generated during your procedure runtime, or if you need to save configuration outside the excel workbook but you want to take care of reading the configuration files. 516 more words
Sometimes, you may come across situation when you can import vba package on one client workstation and get error on another workstation. Below are 2 basic things you should check before digging further on the issue: 23 more words