The tools written in the AFS tool Excel macro are attached to the document for download.
The main function is to write Macros in Excel,
Classify a large amount of data according to a template and generate multiple Excel files
There are three sheets in the AFS tool: info, data, and cover.
Sheet: info mainly describes the user operation interface and software. There is only one button for generating files,
When you click it, the system will prompt you to save the path of the generated file. The file name is generated in a certain format.
Sheet: data mainly stores the data to be processed.
Sheet: the template for generating files in cover. All generated Excel files are generated according to this template,
Only the yellow cell part is the content to be replaced. You can modify it elsewhere, that is, you can modify the template, but cannot modify the yellow part.
Below is:
Tools written in AFS tool Excel macro generate EXCEL files in batches