I mostly write macros in word using VBA. A user
needs to enter a date like this one: 070797 and I need it to look like this:
July 07, 1997 on the document. Can you help? Also, are there other ways of
formatting dates? I've tried putting the date in a variable and doing
something like this:
myDate = DTPicker1.value
format(myDate, "mmm, & " " & mid(3, 2 ) & ", " & right(2))
But, this didn't work.
Jump to Post
You say the book has problems without answers? Is it possibly meant to be used as a student's textbook? If you really like the book, perhaps you can check the publisher's website to see if there is an "answer key" softcover available?
All 11 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.