Learn how to add records from an Excel worksheet into an existing Access table both manually and through VBA code.

​Read Article

Do you know how to extract chart data with VBA? If not, in this article you will learn how to avoid cases where you receive a chart but not the actual data.

​Read Article

Face detection in Excel? Sounds crazy, isn’t it? However, a combination of Artificial Intelligence, C#, and VBA can do this in a few seconds!

​Read Article

Do you know how to enhance the functionality of VBA by using an external C# console application? Sure, it is not easy but can work wonders!

​Read Article

Do you know how to scrape a web page and get information from all the images that it contains? Are you interested in learning how to retrieve the width and the height from a given image URL? The two macros have the answers.

​Read Article

Do you know how to “hide” your macros from the Macros menu in Excel? If yes, then how do you call these hidden macros from a different VBA module? Learn three different possible ways.

​Read Article

Learn how to add dimensions in AutoCAD directly from Excel. The AddDimAligned method is used within a loop so as to draw the necessary dimensions. The VBA code uses late binding, so no reference to external AutoCAD library is required.

​Read Article

Do you have troubles getting the serial number of a USB drive? No need to struggle anymore with small-font numbers and letters. Just run this VBA code and the serial number will be filled in an Excel cell.

​Read Article