Thank you for your help Cindy! It's working great now
Cindy M -WordMVP- wrote:
Hi Jlawson,
I want a macro to run after the user closes a User Form but I want it
to include the current date with the file name. This is what I have so
far:
Private Sub NoticeAccept_Click()
UserForm3.Hide
ActiveDocument.SaveAs FileName:="Schedule Change Request"
End Sub
I want to include the day's date after the file name: "Schedule Change
Request 07-18-06"
FileName:="Schedule Change Request " & Format(Date, "mm-dd-yy")
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)