naming a saved file

[mikeyfear]

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!

[Simon Lloyd]

This should do it for you!

Please Login or Register  to view this content.

[mikeyfear]

This should do it for you!

Please Login or Register  to view this content.

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.

[Simon Lloyd]

This will save it to the same path as the original:

Please Login or Register  to view this content.