Program Word to Save File As...

		Microsoft Office Forums > Microsoft Word > Mail Merge
Program Word to Save File As...

FAQ

Thread Tools

Display Modes

09-21-2014, 07:25 AM

macropod

Windows 7 64bit Program Word to Save File As...

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Charles,

Question: What are you trying to achieve with this:

Code:

        Format((Year(Now() + 1) Mod 100), "20##") & "-" & _
        Format((Month(Now() + 1) Mod 100), "0#") & "-" & _
        Format((Day(Now()) Mod 100), "0#")

instead of, say:

Code:

        Format(Date, "YYYY-MM-DD")

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word VBA - Save file as a string contained within the word (always same row and leng)	RG87	Word VBA	1	05-21-2014 05:39 AM
How do I save a Word file with a macro for distribution?	leemoreau	Word VBA	3	10-04-2013 08:06 AM
Word Mail Merge File Save	mickeyw3340	Mail Merge	2	12-18-2012 11:30 AM
MS Word XP file save	wayne	Word	8	08-15-2011 03:56 PM
Word Macro: Save file as text with current file name	jabberwocky12	Word VBA	2	10-22-2010 12:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.