VBA Button to save worksheet
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
|