2. How to get started
1. Initialize the runtime environment --- Supports VBA
I need a spreadsheet tool that supports VBA scripts. I have tested it.
WPS 2019 VBA version
Microsoft Office 2021 Professional Plus Edition
Please pay close attention to the words in **bold**. If you are using a standard version of WPS, it may not support VBA.
2. You need to grant permission for the script to run:
Because VBA is used, you may encounter warnings about disabling features. You can follow these steps:
Enable or disable macros in Microsoft 365 files
3. Initialize the table
3.1 You need to initialize the relevant settings, such as power. You can pre-set some power levels in a dropdown menu.
Here, using WPS 2019 as an example, select the "Data" tab, click the dropdown box you want to configure, and then click "Insert Dropdown".
Specifically, for the "Model" dropdown, you need to ensure that the model name matches the corresponding orange-colored worksheet name below. I recommend directly copying it; please avoid any spaces or other characters. The script will match based on the name.
3.2 Initialize your device's worksheet
I recommend that you directly copy the existing worksheet to avoid formatting errors.
Right-click "Select Move or Copy" on the existing device connection record worksheet.
Check "Create Copy"
That's all.
3.2 Initialize your envelope
On the final dark gray printed template page, update your sender information.
Currently, I have only tested C5 and DL envelopes, and only the Epson dot-matrix printer. Since it's an Excel file, you, with your expertise in Excel, will surely adjust the template yourself.
4. What does each color of the worksheet represent?
5. Final Note
I'm not a professional VBA programmer, and I know my code is pretty bad. This was originally just for my own use, but I thought it would be helpful to share it with others. If anyone has any suggestions for improvement (although I admit I'm also lazy), please let me know.
Since this script was developed based on commercial software, I'm not sure if it complies with The MIT License. If it does, please ensure that it adheres to the license terms.
闽ICP备2021006864号-7
闽公网安备35020602002794号