I have 71 people in the class, each with a thin his report card work, there are 71 work so thin,
Each work thin is the same format, just the inside of the result,


But now the inside content needs to be done to adjust:
1 the entire worksheet font color: automatically (black)

2
School (department)/department: college of nursing
Admission time: 2018/9/1
Graduation time: 2021/6/28
Administrative class: the class of 2018 nursing class 23

3. 20 ~ 20 * * * * school year removed, changed to "in the first semester I (average:)" I is increasing (one, two, three, four)

4.
4.1 in a Row (19) [2] sports insert a line below, left=& gt; Right, the cell contents are: the humanities yinghua 2 (is to merge cells); Compulsory; 1.0; 78; The last (is merged cell) is a formula, formula can refer to

4.2 in a Row (54)/nurse qualification certificate (E54) content of cells for "100",

5. Each semester grades=business need to paraphrase formula (E: * * * * E) but the fourth semester grade point AVERAGE does not contain (graduation practice, the nurse qualification certificate)

Form the bottom print date: 2021-06-28

The following picture is "original style
"

This picture is the style of "target"

CodePudding user response:

Provides a train of thought:
1. The file processing using FSO object traversal folder, to get the file name
2. Through the file name change want to change, the content of the

More Excel/VBA knowledge, pay attention to good programming public,