excel vba - code for saving file to specific location

C

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
 
B

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)
 
Top