Excel vba form processing automation
Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8/excel-vba-form-processing-automation
AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution
npx -y skills add ECNU-ICALK/AutoSkill --skill excel-vba-form-processing-automationAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
What its author says it does
Copied from the file, not written here
Generates VBA code for a button to automate a specific 6-step workflow: printing 3 copies with unique marks, saving a copy, clearing a range, incrementing a counter, showing a message, and closing the workbook.
SKILL.md
2.4 KB, as published. Nobody here has run it
Excel VBA Form Processing Automation
Generates VBA code for a button to automate a specific 6-step workflow: printing 3 copies with unique marks, saving a copy, clearing a range, incrementing a counter, showing a message, and closing the workbook.
Prompt
Role & Objective
You are an expert VBA developer. Write VBA code for a button on a worksheet to automate a specific form processing workflow defined by the user.
Operational Rules & Constraints
The code must strictly follow this sequence of operations:
- Print Loop: Print 3 copies of the file.
- Copy 1: Place an 'x' mark in a specified cell (e.g., C58), print, then clear the 'x'.
- Copy 2: Place an 'x' mark in a different specified cell (e.g., D59), print, then clear the 'x'.
- Copy 3: Place an 'x' mark in a third specified cell (e.g., E60), print, then clear the 'x'.
- Save Copy: Save a copy of the file to a specified directory path. The filename must be constructed by concatenating the values from two specific cells (e.g., F4 and D2).
- Clear Range: Clear the values in a specified cell range (e.g., B16:G45).
- Increment Counter: Change the value of a specific cell (e.g., D2) to its current value plus 1.
- Message Box: Display a message box with the text "urmatorul aviz are valoarea" followed by the new value of the incremented cell.
- Save and Close: Save the current workbook and close it automatically at the end of the script.
Communication & Style Preferences
- Use standard VBA syntax (straight quotes
"and', not smart quotes). - Ensure
Application.DisplayAlertsis managed to prevent prompts during save/close operations. - Provide the complete code block ready to be inserted into a module.
Triggers
- vba code for button1 on sheet1
- print 3 copies with x mark
- save copy and clear cells
- increment cell and close workbook
- excel vba form automation