Ideas and tutorials about software design and development.

How-to Import Data From Another Workbook in Excel Using VBA

Although launched in 1985, Excel is still extremely popular in most industries and is used by almost every company one way or another. Some functionalities of the application could only be utilised by using VBA, which then makes this older software even more helpful when analysing and manipulating data.

Aug 20, 2021

Visual Basic Excel Tutorial – How to Automate Repetitive Tasks in a Spreadsheet

I use VBA, or Visual Basic for Applications, to automate my repetitive tasks. This saves me quite a lot of time in my day-to-day life. Based on the fact that you are reading this tutorial, I assume that you would like to be able to do the same.

Jul 29, 2021

How-to Create an Excel File in Node.js with Axios and Excel4Node

Most of the time you most-probably want to use the data of an API on your website or in your application. Though, sometimes it might be that you are willing to download the data you got in an easy-to-read Excel (.xlsx) file. Luckily for us, Node is providing this option with the Excel4Node package. Let’s see how this works!

Jan 5, 2020