Using VBAToolKit

Quick Intro

A VBA Project managed with VBAToolKit is associated with a folder (see the project folder description). The name of this folder is the same as the project. Main subfolders and files of the project structure, assuming your project is named SampleProject are:

• Project\SampleProject_DEV.xlsm is the main Excel workbook in which you'll develop and test your VBA Modules, Classes and UserForms
• Delivery\SampleProject.xlsm (you might choose .xlam if you prefer) is the file to be delivered to the users and customers of your project (including yourself if you are also a user, not only a developer). This file is generated by VBAToolKit based on the project configuration
• Template subfolder contains files to be used as templates for tests or for Excel workbook generation (not yet implemented)

A project can manage several configurations. A configuration is mainly an Excel worksheet composed of VBA components (modules, classes, UserForms). By default, a project named SampleProject has two configurations named SampleProject (the configuration to deliver) and SampleProject_DEV (the configuration for development and tests).

General usage

Create a Project You add and ma 1/ structure de folder 2/ le projet se situe dans projet

On fait le code Trucs - tests VBAUnit (using) autre trucs fonctions qui permettent de coder

• vtkTestPath (il faudra ajouter d'autres fonctions, par exemple getTestFileFromTemplate, getTestFolderFromTemplate, resetTestFolder)

Ajouter un module au projet Expliquer la démarche et le fichier de configuration (il faudra ajouter cette fonction plus tard)

Gérer les configurations Paramètres (type, chemin) créer une configuration plus tard - template d'Excel, paramètre supplémentaire (il faudra ajouter cette fonction plus tard)

3 Functions actuelles

Create a Project

Export modules (automatique)

Regénérer une configuration