Make your office life easier with simple and fast Excel VBA solutions.
In the doughnut type charts Excel gives You no option to change the position of data label. The only setting is to have them inside the chart. But is this making You not able to make doughnut chart with outside end labels?
I’ve already discussed how to Connect to SAP via Excel VBA and 10 code lines you can identify in SAP code. But I haven’t explained how to record a macro in SAP yet. In this article I’m going to explain You step by step how to record a macro in SAP using SAP Script Recording.
I’d like to invite You to my second YouTube tutorial video, which is about the most common error in arrays. Watch it here or go to my channel.
Enjoy the video, leave a like and subscribe to my channel!
Last time I showed You how to loop through folders and files. But was that the fastest way? In today’s article I’m going to compare the speed of loops through files methods and get the fastest way to find the file.
We often write tools that process files in a given location, i.e. in a given folder. Sometimes it is even whole structure of folders with files. In today’s article You will learn how to loop through folders and files to find the one You look for.
Until now I was only writing about HTTP methods, but did not really describe the final trick to download the file from URL. In today’s article I want to present You and compare two methods of downloading files from URL – URLDownloadToFile function and saving byte array to file method.
