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