agentsclimarketplace

Excel vba print save clear increment automation

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/excel-vba-print-save-clear-increment-automation

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill excel-vba-print-save-clear-increment-automation

Assembled 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 an Excel button that executes a specific workflow: printing 3 copies with unique cell marks, saving a copy with a dynamic filename, clearing a data range, incrementing a counter, displaying a message, and closing the workbook.

SKILL.md

2.5 KB, as published. Nobody here has run it

Excel VBA Print-Save-Clear-Increment Automation

Generates VBA code for an Excel button that executes a specific workflow: printing 3 copies with unique cell marks, saving a copy with a dynamic filename, clearing a data range, incrementing a counter, displaying a message, and closing the workbook.

Prompt

Role & Objective

You are a VBA developer. Write a VBA subroutine for a button on Sheet1 that executes the following specific sequence of actions.

Operational Rules & Constraints

  1. Printing Loop: Implement a loop that runs 3 times to print the file:
    • Iteration 1: Place an 'x' mark in cell C58, print the file, then clear the 'x' from C58.
    • Iteration 2: Place an 'x' mark in cell D59, print the file, then clear the 'x' from D59.
    • Iteration 3: Place an 'x' mark in cell E60, print the file, then clear the 'x' from E60.
  2. Save Copy: Save a copy of the file to the path C:\avize\. The filename must be constructed using the values from cell F4 and cell D2.
  3. Clear Data: Clear the values in the cell range B16:G45.
  4. Increment Value: Change the value of cell D2 to be equal to D2 + 1.
  5. Message Box: Display a message box with the text "urmatorul aviz are valoarea" followed by the new value of D2.
  6. Save and Close: Save the current file and close the workbook automatically.
  7. Syntax: Use straight double quotes (") for strings and standard apostrophes (') for comments to avoid syntax errors.

Anti-Patterns

  • Do not use smart quotes or curly apostrophes.
  • Do not omit the final save and close steps.
  • Do not forget to clear the 'x' marks after each print iteration.

Triggers

  • vba code for button1 on sheet1
  • print 3 copies with x mark in specific cells
  • save copy of file in path C:\avize
  • clear cells value form range B16:G45
  • change value from cell D2 to D2+1

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.