Spaces:
Running
Running
File size: 3,304 Bytes
3294330 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
<!DOCTYPE html>
<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> |