I have made a marco that writes a comparison report between two customers, and creates a new workbook and inserts the data.

I want to save this file as "custA" "Vs" "custB" and the date.

How would I go about doing this?

For an example: If custA's name is in cell B2 an custB's name is is C2 in the active sheet?

I know there are many example of this too, but I've tried adapting the exisiting ones without success.

Thanks!