Print Multiple Workbooks
 

Hi

In the past, we have created a spreadsheet which creates a new worksheet
containing statements for all clients from another worksheet. This new
worksheet may hold 700 statements but this is fine.

We have recently had some software created which is excellent apart from
now, the statements are created as individual workbooks in a folder. THis is
run every 2 months so every two months, a new folder is created with all new
workbooks in.

I need help in finding a way to be able to print all workbooks without
having to open each one individually and selecting print. Very time
consuming.

I am aware that this is probably going to be some coding of some sort, so
could you please be as descriptive as possible as I am not a programmer of
any sort.

Any help is greatly appreciated.

Thanks in advance

Malcolm