Project Folder Structure

When you create a new VBA project via VBAToolkit, the created project directory has specific subfolders.

Project
This directory contains the Excel workbook used for developing the project just created — typically with all the test modules. This workbook has a sheet that keeps track of the project modules activated in both this workbook and in the delivery workbook located in the Delivery directory.

Delivery
This directory contains the Excel workbook containing the VBA project itself, ready for delivery to the users. The name of this Excel workbook is the name of the project created with VBA Toolkit.

Source

• Source/VBAUnit : This directory contains the source code of the open-source unit-testing VBAUnit modules. These modules are used in the TDD (Test Driven Development) approach VBAToolKit aims to promote.
• Source/ConfTest : This directory contains the source code used for test purposes (e.g. tester modules)
• Source/ConfProd : This directory contains the source code of the actual application to be delivered to users.

Tests
This directory is used for test purposes : this is where we will create dummy files and such. This directory is generally erased at the end of a test campaign, so it must contain no permanent files; see Templates directory instead.

Templates This directory contains files that will be used as templates by the testing code (Excel Sheet formatted a certain way, DataBase, text file, etc).