^{WIN32 / WIN64 / VBA7 (MS Office 2010+)}

This repository contains both; ds3x, a lightweight MSAccess (VBA) shared library providing a dead simple abstraction over operating on lists and table-like types of data collections and, the dsLiveEd, a PowerQuery-like MSAccess Application for managing automation tasks of data manipulation or direct-data manipulation with it's Live Editor interface.

Current releases are pretty stable but this is still in active development, being released earlier than planned so anything can be subject to change. Also, I'm still considering to use a custom ArrayList implementation to get rid of the .NET Framework v3.5 dependency.

This documentation is still largely incomplete.

Read the dsLiveEd docs here.

Read the ds3x shared library docs here.

• ArrayListEx - .NET Framework v3.5's ArrayList wrapper.
• Array2dEx _^IMMUTABLE - VBA's built-in 2D Array wrapper.
• DictionaryEx - Scripting.Dictionary wrapper.
• RecordsetEx - ADODB.Recordset wrapper.
• xlSheetsEx - CSV/Excel wrapper.
• dsTable _^IMMUTABLE - Greatly simplifies working w/ table-like collections (holding column-related info, not just data).
  
  

• All collection-type classes are limited to VBA's Long capacity, 2,147,483,647 rows ^_x 2,147,483,647 columns, being 4,611,686,014,132,420,608 cells in total.
  (There's a task for de live editor app that creates a 2,100,000,000 * 1,000 sample table for quick development which only consumes about 17MB of VMem and takes less than a second to generate.)
• No support implemented for Mac or MS Office versions previous to 2010.