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.
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.
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.
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.
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.