Excel VBA


Card image


Automatization of process or tasks using Excel VBA

Go Back



Description



Solutions to automatize process or tasks defined by the users.
The solutions in this category store the data in the Excel itself.
The Excel database can be a Compact Database (many columns in one cell) or not.

Examples of Applications:

  1. Upload of data from text files
  2. Generation of files for integration with other systems
  3. Generation of PowerPoint Presentations directly from Excel
  4. Development of Reports
  5. etc




Typical Phases


  1. Requirement gathering
  2. Implementation - coding of the macros
  3. Deployment- tests and improvements