excel vba - code for saving file to specific location

[chief]

does anybody know code that can be written so that when a command butto
is clicked it will save the worksheet to a specific location folder

 

[Bob Phillips]

With Activeworkbook
.saveas Filename:="C:\specific folder\" & .Name
End WIth

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)