Solved: Saving File - Automated File Naming

[thomas.szwed]

Thanks XLD, this is great. Could i ask for two further solutions.

1. How can we edit the code so a comma appears between all three bits of text i.e CellC3,Cotnract,CellG9. Currently there are no commas.

2. This is much trickier. Cell C3 contains a name in full i.e. John Smith.

I need my naming convention to go like this.

Surname, Forename, 'Contract', CellG9.xls

Is there anyway in the code to pull out that fullname from Cell C3, split it up and then put in order surname, forename.......??

I know this seems tricky, wondering if it can be automated?

I dont have much room to play with on the sheet aswell, as I am using it as a userform and altering columns etc would not work.....

Thanks in advance...