Best Tools and AI Models for VBA Macro Generation
For running local AI models to generate VBA macros, here are recommended tools and models:
- Tools: Ollama (for easy local LLM deployment), LM Studio, or Text Generation WebUI. These allow running models locally on your machine without internet dependency.
- AI Models (LLMs):
- Llama 3.1 or 3.2 (7B-70B parameters) for balanced performance and VBA knowledge.
- Gemma 2 (2B-27B) for efficient local running with good code generation capabilities.
- Mistral 7B or Mixtral for strong reasoning in macro scripting.
- Phi-3 (3.8B) from Microsoft, optimized for coding tasks like VBA.
- Knowledge Source: These models draw from their training data, which includes extensive VBA documentation, Excel/VBA APIs, and programming examples. For enhanced accuracy, fine-tune on datasets like VBA code snippets from GitHub or official Microsoft docs. Knowledge is derived from pre-trained corpora covering software development, scripting, and automation.