Everyone a great god, work out a little bit difficult, there are more than one thousand EXCEL file, I don't know how to batch Settings page format and print, can guide it to me

CodePudding user response:

The same problem, such as the great god answered

CodePudding user response:

Recording a macro, according to the macro code it is ok to write a VBS;

CodePudding user response:

Using vb to write a small program loop handle these 1000 documents, handle them one by one, with VBA, specific code can record macro view, ported to vb.

CodePudding user response:

The first recorded macros,
The second step is to macro code,

1, increase reads the specified folder all the cycle of EXCEL file
2, each read a, open, the implementation of the macro code
3, save, close,
4, continue to the next file