software

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: quot;Joe Bloggs
27th January 2006quot;. Customers name is in cell B1 and date in cell C1.
is it possible to record a macro that will do this.--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: www.excelforum.com/member.php...foamp;userid=4700
View this thread: www.excelforum.com/showthread...hreadid=505656No, but it is simply

Sub SaveData
Activeworkbook.SaveAs Range(quot;B1quot;).Value amp; Format(Range(quot;C1quot;).Value,quot;dd
mmmm yyyyquot;)
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Chris Watsonquot; gt;
wrote in message
news:Chris.Watson.22a9pm_1138348502.0661@excelforu m-nospam.com...
gt;
gt; I have created an Invoice which has a customers name and date. I have
gt; put in a save button using autoshape and want to record a macro that
gt; will save the invoice with the customer name and date, ie: quot;Joe Bloggs
gt; 27th January 2006quot;. Customers name is in cell B1 and date in cell C1.
gt; is it possible to record a macro that will do this.
gt;
gt;
gt; --
gt; Chris Watson
gt; ------------------------------------------------------------------------
gt; Chris Watson's Profile:
www.excelforum.com/member.php...foamp;userid=4700
gt; View this thread: www.excelforum.com/showthread...hreadid=505656
gt;