After building a minimal FastAPI + SQLite CRUD application in Docker, I wanted to show how Excel can connect directly to it. With a few lines of VBA, we can turn Excel into a client that talks to the API. …
Docker Basics in Excel with VBA | Full CRUD Demo Read more →
If you are just starting with Docker and want a practical project, here is a fun one: let’s build a tiny CRUD app in Python, run it inside a Docker container, and then connect to it from Excel with VBA. …
Docker + Python CRUD API + Excel VBA – All for beginners Read more →
Sometimes, the graphs of stocks are useful. Sometimes these are not. In general, do your own research, none of this is financial advice. And while doing that, if you want to analyze stocks with just a few lines of python, …
Ok, currently the BTC is 68 491,28 USD and instead of feeling bad for not buying it, you can try to simulate it the mining process with Python just for fun. It is an interesting way to have fun, but …
Python – Simulating the Bitcoin Mining Process – YouTube video Read more →
Here is an explanation of the Central Limit Theorem (CLT) in a few simple points: Explanation: The Central Limit Theorem states that the distribution of the sample means (averages) of a large number of samples from any population will be …
Hi there, if you ever need a quick renamer of files in forlders – that is the VBA code you may use: Option Explicit Sub ChangeNames() Dim fso As New filesystemobject Dim fol As Object Dim fil As Object Dim …
VBA – Quick Renamer of files in folders with VBA Read more →
In the current article I proudly present a simple application, which creates a simple Excel file from XAML. In the example I present I am using Excel 2010 as this is my current version. In order to be able to …
In this article I present a code from the book “Pro WPF 4.5. in C#“, which I consider useful and interesting. The application concerns building a simple program where you may ask a yes-no question and get a random answer. …
In this article I present the combination of a drop-down menu and audio in a WPF application. Simply, the application’s logic is the following – you select one media file from a drop-down list and then you play it. The …