Hi Dev,

The SaveAs method fails because it is trying to save the workbook up 3
levels from the bin directory where Serial Worksheets does not exist.
Anyone have any ideas what is going on?

I think the ReportPath will need to be a fully-qualified path, not a
relative one.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk