Macro recording?????

[Chris Watson]

I have created an Invoice which has a customers name and date. I have
put in a save button using autoshape and want to record a macro that
will save the invoice with the customer name and date, ie: "Joe Bloggs
27th January 2006". Customers name is in cell B1 and date in cell C1.
is it possible to record a macro that will do this.

 

[Bob Phillips]

No, but it is simply

Sub SaveData
Activeworkbook.SaveAs Range("B1").Value & Format(Range("C1").Value,"dd
mmmm yyyy")
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Chris Watson" <[email protected]>
wrote in message
news:[email protected]...