naming a saved file

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!

Originally Posted by Simon Lloyd

This should do it for you!

ThisWorkbook.SaveAs (Range("B2").Value & " Vs " & _
Range("C2").Value & "-" & Format(Date, "dd-mm-yyyy"))

Thanks Simon. Just out of interest is there any method to display the current path a workbook is saved in?

I'm thinking if I could look that up on my original workbook, set it as a string in the macro that crates a new one, then I could make it automatically save it in the same place as the original workbook that creates the new one.