Spaces:
Running
Running
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <meta name="description" content="VBA Macro Generator Tool - Use local AI to generate VBA macros based on your descriptions."> | |
| <meta name="keywords" content="VBA, macro generator, local AI, LLM models"> | |
| <title>VBA Macro Generator</title> | |
| <link rel="stylesheet" href="assets/css/styles.css"> | |
| </head> | |
| <body> | |
| <header> | |
| <div class="header-content"> | |
| <h1>VBA Macro Generator</h1> | |
| <a href="https://huggingface.co/spaces/akhaliq/anycoder" target="_blank" class="anycoder-link">Built with anycoder</a> | |
| <div class="top-graphic"> | |
| <img src="assets/images/tits-graphic.png" alt="Decorative graphic" width="100" height="60"> | |
| </div> | |
| </div> | |
| </header> | |
| <main> | |
| <section id="tools-models"> | |
| <h2>Best Tools and AI Models for VBA Macro Generation</h2> | |
| <p>For running local AI models to generate VBA macros, here are recommended tools and models:</p> | |
| <ul> | |
| <li><strong>Tools:</strong> Ollama (for easy local LLM deployment), LM Studio, or Text Generation WebUI. These allow running models locally on your machine without internet dependency.</li> | |
| <li><strong>AI Models (LLMs):</strong> | |
| <ul> | |
| <li>Llama 3.1 or 3.2 (7B-70B parameters) for balanced performance and VBA knowledge.</li> | |
| <li>Gemma 2 (2B-27B) for efficient local running with good code generation capabilities.</li> | |
| <li>Mistral 7B or Mixtral for strong reasoning in macro scripting.</li> | |
| <li>Phi-3 (3.8B) from Microsoft, optimized for coding tasks like VBA.</li> | |
| </ul> | |
| </li> | |
| <li><strong>Knowledge Source:</strong> 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.</li> | |
| </ul> | |
| </section> | |
| <section id="macro-generator"> | |
| <h2>Generate VBA Macro</h2> | |
| <form id="macro-form"> | |
| <label for="macro-description">Describe the Macro:</label> | |
| <textarea id="macro-description" name="description" placeholder="E.g., Create a macro that loops through a range of cells in Excel, checks if the value is greater than 10, and highlights the cell in yellow." required></textarea> | |
| <button type="submit" id="generate-btn">Generate Macro with Local AI</button> | |
| </form> | |
| <div id="output"> | |
| <h3>Generated VBA Macro:</h3> | |
| <pre id="macro-code"></pre> | |
| <button id="save-btn" style="display:none;">Save Macro to File</button> | |
| </div> | |
| </section> | |
| </main> | |
| <footer> | |
| <p>© 2023 VBA Macro Generator. Use local AI models responsibly.</p> | |
| </footer> | |
| <script src="assets/js/app.js"></script> | |
| </body> | |
| </html> |