VBA Button to save worksheet

[TheSAguy]

I’d like to create a button in excel that will save the document to a
specific location with a specific name. It’s an Invoice template.

Example, You will fill out the spread sheet, In cell A1, you will enter your
invoice number.

Then when you press the button you created, lets call it "Save", it will
save the worksheet in “C:\temp\†with a name “A1â€.xls. where A1 is pulled
from cell A1. Something like: 011a.xls


Is that possible?

 

[TheSAguy]

Thaks Dave,
That worked great!

Option Explicit
Sub Testme()
with activesheet
.parent.saveas filename:="c:\temp\" & .range("a1").value & ".xls", _
fileformat:=xlworkbooknormal
end with
end sub