Wrote for a file name fill into the form of macros, run on a smooth, but also bcde... Two hundred multiple files to repeat the operation, don't know how to let other excel can also carry out the macro, strives for the great god,

CodePudding user response:

It is ok to replace vba with VBS;

CodePudding user response:

Dim tmpSht as worksheet
For each tmpSht worksheets in
'your action code
Next

Probably thought is traversed each work table

CodePudding user response:

Thank you for your enthusiastic help great god, problem solved