Formatting Bookmarks

Question

I'm currently using VBA to bring data from Excel to Word.  I simply have the VBA put the Excel data into bookmarks.  However, it always uses the date format (MM/DD/YYYY).  How can I change it so that the date format is the long date format (ie January 1, 2010)?

Thanks!

Using Office 2007

Answer 1

Use the VBA Format() function to format the date as you want it.

Format([thedate], "mmmm d, yyyy" )

where [thedate] is what you are obtaining from Excel.

-- Hope this helps.

Doug Robbins - Word MVP,

dkr[atsymbol]mvps[dot]org

Posted via the Community Bridge

"jtrevill" wrote in message news:*** Email address is removed for privacy ***...

I'm currently using VBA to bring data from Excel to Word.  I simply have the VBA put the Excel data into bookmarks.  However, it always uses the date format (MM/DD/YYYY).  How can I change it so that the date format is the long date format (ie January 1, 2010)?

Thanks!

Using Office 2007

---

Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org

Answer 2

Ha!  Thanks so much - I was so stuck on figuring out how to change the way the Word Bookmark handled the date.

Thanks for the simple solution!