mm/dd/yyyy to Month Day, Year VBA

[Toast83]

Hey all,

First post on here and I'm a brand new VBA user. I'm trying to pull data from Excel into the form fields of a Word document I've created. Some of the data I'm trying to pull are dates formatted as mm/dd/yyyy, but needs to be in Month Day, Year format for the document (i.e. "02/04/2013" needs to pull over as "February 4, 2013").

Any thoughts are much appreciated!

- RCT

 

[BAlGaInTl]

Something like this should work. You can modify to suit your needs.

Sub DateText()
Dim dDate As Date
Dim sDate As String

dDate = Range("A1").Value
sDate = Format(dDate, "mmmm dd, yyyy")
MsgBox (sDate)

End Sub

 

[Toast83]

Perfect! Thanks for the help.