Tag: Excel

How to make doughnut chart with outside end labels

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?

doughnut chart with outside end labels homer donut
Continue reading “How to make doughnut chart with outside end labels”

Record macro in SAP using SAP Script Recording

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.

Record macro in SAP using SAP Script Recording Morfeus
Continue reading “Record macro in SAP using SAP Script Recording”

The fastest way to find the file in chosen location

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.

The fastest way to find the file in chosen location jeremy clarkson
Continue reading “The fastest way to find the file in chosen location”

How to loop through folders and files

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.

loop through folders and files liam neeson
Continue reading “How to loop through folders and files”