Data and loops | Category

Calculations in Excel requires data that can be imported from files, databases or the Internet but can also be entered manually. In this category you will find free templates that includes data import, storing of data in collections and loops to process data.

Collection of objects in Excel (VBA and VB6) | Free code

Here you can download free code that shows you how a collection of objects can be used in VBA code for programming in Excel, when you need to manage data in lists.

Import data from MS SQL database to Excel (VBA and VB6) | Free code

Here you can download free VBA code to import data from a MS SQL database to Excel by connecting to a SQL Server, open a database and run a SQL command against the database.

Multi-dimensional array in Excel (VBA and VB6) | Free code

Here you can download free code that shows how a multidimensional array can be used in VBA code for programming in Excel.

One-dimensional array in Excel (VBA and VB6) | Free code

Here you can download free code that shows you how a one-dimensional array can be used in VBA code for programming in Excel.