Beispiele MSO
   Film: «Word ist doof»
   Word aus Vermassung
   Rechnung in Word
   Excel aus SAP
   DTA-Dateien aus Excel
   Verbund Access-Word
   Alles ist möglich!
Beispiele Web


Visual Basic for Applications

VBA stands for Visual Basic for Applications. Microsoft created VBA in 1997, as a dialect of Visual Basic (VB).

The phrase "for Applications" means that VBA is designed to interact with Microsoft Office applications. In other words, VBA automatizes the applications Word, Excel, PowerPoint, and Access and provides them with (almost) any extra functionality

A clear user interface places these extra features at the user's disposal. Good VBA programming comes along with a complexity and a look-and-feel not distinguishable from other Windows applications.

We are committed to high quality standards in VBA development. They include strictly typed variables, a consistent naming convention (LNC), consequent structuring in manageable modules, error trapping, a self-explanatory user interface, detailed feed-back for batch processes as well as a transparent change management.

We use both techniques of procedural and object-oriented programming.

Own examples:

MS Word: Stationery with guided initialization
Automated billing
Neural network
MS Excel: Processing SAP data
Generating DTA files (electronic funds transfer)
MS PowerPoint: Compliance to CI standards, and automatizations
MS Access: Database interacting with MS Word
Systems: MS Access–MS Word
Mainframe–MS Access–MS Excel–MS Word

Contact us if you have projects similar to the ones above.

Trigonella GmbH, Basel
VBA, Word, Excel, PowerPoint, Access – HTML, JS, PHP, MySQL