'How to Code Quality on EXCEL VBA Code in SonarQube or Alternatives?
We've have codebase with VBA/EXCEL. Which SonarQube plugin can analyze VBA inside excel or outside as text file. We can copy VBA to .vba text file if this is possible.
If not is there any other tool which can help us perform Code Quality on these languages.
Solution 1:[1]
SonarSource provides a commercial plugin for Visual Basic 6. It may work for VBA if the syntax is the same.
Solution 2:[2]
You can find the best tool to quality check your Excel VBA code at xatocode.com.
This is a relatively new tool, but very slick. There is no other tool out there which is as good as this one. It can not only review your Excel VBA code against some standards, but also help you navigate through your code in a tree view format, download pre built code snippets and much more.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Pierre-Yves |
| Solution 2 |