Id like to create a button in excel that will save the document to a
specific location with a specific name. Its 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?

Thaks Dave,
That worked great!


"Dave Peterson" wrote:

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


TheSAguy wrote:

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?

--

Dave Peterson