Hello,

I would like to open a series of files one at a time, print them and then
close before opening the next.
The files will be named in order, for example AAA1.xls, AAA2.xls, AAA3xls,
etc. and will be in the same directories.

Please could someone help me out in terms of writing the macro so it will
open each file in turn (there are too many files to open in one go).

Thanks