VBA Boilerplate
Dreaming of having a boilerplate for Excel VBA project? Or you have other dreams, which are more normal? Well, I cannot help in the latter case, but if you want a boilerplate for VBA – here it is!
Month: December 2019
C# – Build a .NET Standard library with Visual C# – Video
Following the Microsoft tutorial for building a .Net Standard library with Visual Basic from here, I have decided to make a video for .Net Standard library with C#. Pretty much, it is one and the same. The library contains one …
C# – Build a .NET Standard library with Visual C# – Video Read more »
Writing data from text file to Excel cells
There are quite a few methods for writing data from a text file to Excel. The main are the following: Through a Query Table Through opening the text file and Reading and writing line by line Reading the text file, …
Python – UnitTests in Jupyter Notebook
Unit testing is the “sweet” part of the programming – once you have tested “all the things”, you feel that the code you have submitted somewhere is actually valid and somehow it works. Furthermore, it allows you to nicely brag …
Book Review – Stephen Wolfram – Adventures of Computational Explorer
Some time ago, I have received the book of Stephen Wolfram – Adventures of Computational Explorer for a review. Stephen is the guy behind WolframAlpha – https://www.wolframalpha.com/, a PhD in physics before his 21. birthday, considered a prodigy by some …
Book Review – Stephen Wolfram – Adventures of Computational Explorer Read more »
VBA – Extracting financial data from a website in table format
Although there are plenty of other tools for extracting data from a website (take a look at Beautiful Soup), VBA is somehow good, because … well, because it is somehow challenging to do it every time. Yesterday, I answered a …
VBA – Extracting financial data from a website in table format Read more »