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.
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.
Here you can download free code that shows how a multidimensional array can be used in VBA code for programming in Excel.
Here you can download free code that shows you how a one-dimensional array can be used in VBA code for programming in Excel.
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.