Thankyou very much for your help this worked well...

"JE McGimpsey" wrote:

This is rather an FAQ if you look in the archives:

http://groups.google.com/advanced_gr...=group:*excel*

One way:

Public Sub SaveInB2AsA2()
Const sPATH As String = "R:/SALES/Team 318/"
ThisWorkbook.SaveAs _
Filename:=sPATH & Range("B2").Text & _
Application.PathSeparator & Range("A2").Text & ".xls"
End Sub



In article ,
"Andy" wrote:

Two cells A1 & B2

I am trying to create a Macro to attach to a button to Save an .xls as

"A1".xls in directory R:/SALES/Team 318/"B2"

instead of typing it in all of the time....

Any helpers? Past attempts at this have failed.....the winner will get a big
MVP vote!