[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"

Thank you!

[Cindy M -WordMVP-]

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 :-)

[jlawson]

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 :-)