macro for save as using concetenation of 2 cells as file nam

[cocosoft]

G'day Guys & Gals from Australia.
Can someone help with my subject matter.
I need to be able to run a macro which will join the contents of 2 cells i.e. A1 (Customer Name) & X1 (Quote number)with a hyphen in the middle and use the result for the filename. I would like the macro to autorun when Both cells have been filled.
Any thoughts please.
Cheers Coco

[Tom Schreiner]

Cell A1 and X1?
Or does X stand for a variable column?
Tom

[Tom Schreiner]

This code does not specify a path but simply saves the active workbook as the name you wanted.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Or _

   Target.Address = "$X$1" Then

    If Len(Range("A1")) <> 0 And _

        Len(Range("X1")) <> 0 Then

        ActiveWorkbook.SaveAs _

        Range("A1") & "-" & _

        Range("AX1") & ".xls"

    End If

End If

End Sub

Tom

[cocosoft]

Thanks a million Tom., I think that will get me out of trouble. If not I will certainly be able to adapt it.
I am going to post a much curlier problem tomorrow, I hope you get to see it, I'll be interested to see if you have any ideas on my next one.
Thanx again mate -- First time I have ever used a resource like this and you have made my introduction a pleasure.
Cheers Bob Cohen AKA Coco