Hi Peter,

Active.SaveAs "H:\?" & Format(Activesheet.Range("C2"), "dd mmm yy")

Check out Ron de Bruin's site at www.rondebruin.nl/sendmail.htm for sendmail
options.
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Peter" wrote in message
...
Hi,

I have a user form that I have almost got sorted except for a few
things. One of these is saving the spreadsheet.

In cell C2 of the spreadsheet associated with my user form has a date
in it. Can anyone please advise if it is possible to use the contents
of cell C2 in the following line in place of the ?'s such that the
spreadsheet saved in the H drive would have the name, say, 23 Oct 04

ActiveWorkbook.SaveAs "H:\?????????", -4143

Similiarly, another line

ActiveWorkbook.SendMail ", "?????????"

sends the spreadsheet as an enclosure. Is it possible to again use the
content of C2 as the title of the email, replacing the ?'s in the
above line?

Any suggestions would be much appreciated.


--
Cheers

Peter

Remove the INVALID to reply