Not quite, South Coast of England.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy" wrote in message
...
Thanks Bob.....this did the trick as it was the least code for the three
responses. I appreciate your help. Youre not from Brisbane?

"Bob Phillips" wrote:

ActiveWorkbook.SaveAs Filename:= "R:\SALES\Team 318\" &
Range("B1").Value &
"\" & Range("A1").Value & ".xls"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy" wrote in message
...
Hi

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!

Absolute respect

Andy