VBA Save Workbook with min and max date range

[DoodlesMama]

I am creating a report that needs to save a copy with the min and max contact dates and also adds these dates in the report header. The formulas I've created below are not working. Can you please help me figure out what I am doing?

Save copy of the Report

Please Login or Register  to view this content.

Create Report Header

Please Login or Register  to view this content.

Any help offered is greatly appreciated.

[ARGK]

Hi
My initial thoughts are that you cannot have an operand in the file name. You have a minus sign there, trying changing it to a ":" for example and see if that works or even an underscore "_".
Tony