VBA Button to save worksheet

T

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?
 
T

TheSAguy

Thaks Dave,
That worked great!


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top