Need help creating a document with 365 images, with a day of the year 2018 captioned on each image.

		Microsoft Office Forums > Microsoft Word > Word VBA
Need help creating a document with 365 images, with a day of the year 2018 captioned on each image.

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-03-2017, 08:25 PM

macropod

Windows 7 64bit Need help creating a document with 365 images, with a day of the year 2018 captioned on each image.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

You could add the following function to the same code module you use for Graham's code:

Code:

Function DateOrdinal(Val As Long) As String
Dim strOrd As String
If (Val Mod 100) < 11 Or (Val Mod 100) > 13 Then strOrd = Choose(Val Mod 10, "st", "nd", "rd") & ""
DateOrdinal = IIf(strOrd = "", "th", strOrd)
End Function

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to search for a specific year from a table with year range?	Wii	Excel	0	05-05-2015 12:40 PM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Need advice on creating new .pst files every year	Rockitman31	Outlook	1	03-02-2013 08:00 AM
Creative Ways for a year-to-year comparison???	ridonkulous5	Excel	1	03-23-2011 04:49 PM
Referencing a Captioned Picture	ComcoDG	Word	0	11-10-2008 04:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:13 AM.