Hi,

I have a macro workbook that opens two report templates, copies data into
them, creates subtotals and formatting, then saves the two reports using
SaveAs...

Unfortunately every time the code reaches the line:
Workbooks("Rep_Template1").SaveAs sRepName

or

Workbooks("IntRep_Template1").SaveAs sRepName

Surely these are correct references - they've worked fine for 5 years!

I get an error 'Automation Error The object invoked has disconnected from
its clients'

Excel then crashes with a memory leak or something...

This tool has been running finr for 5 years under Excel 97 and Excel 2000
and now I am getting this error.

Has anyone seen this, and how can I fix it...I've tried copying all the
sheets and VBA objects into a new workbook but that has not worked either...

I'd be grateful for any help

Philip