#1
|
|||
|
|||
need help with macro date and time for dispatch sheets
i need help setting up a macro on windows Office Xp 2002 that will automatically print off 4 sheets with the date and time for the next month to come. we recentlyu lost a computer with 2007 which had the macro working, but it seems when we try to print out the log sheets it doesnt print the date and time. i'm not sure if you will understand this or not so please ask questions and i'll try to better information... thanks...
Last edited by Jamesb8488; 04-28-2011 at 12:38 PM. Reason: uploaded the Dot file i am trying to get working.. |
#2
|
||||
|
||||
Hi James,
I see your doument uses one of my date calculations fields as the basis for calculating the date on each page. See: http://windowssecrets.com/forums/sho...ation-Tutorial and: http://www.gmayor.com/downloads.htm#Third_party Given that you're using a macro to drive the document, the same thing could be done soemwhat more simply in vba. Your document's filesize would also be somewhat smaller too. With either approach, it's also easy enough to modify the code so that the document can be printed on any day of the week. As for the date & time stamp, I take it that what you're after is the print date & time. Assuming this is to go into the document's page header or footer, it's just a simple matter of inserting a PRINTDATE field there, coded along the lines of: {PRINTDATE \@ \@ "hh:mm AM/PM 'on' DDDD MMMM DD, YYYY"} where the field braces (ie '{}') are created via Ctrl-F9.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creating macro for biffurcation in sheets according to data. | Nirik | Excel Programming | 8 | 05-07-2011 05:11 AM |
Date and time calcs excluding non-working hours | mrsatchmo | Excel | 1 | 01-26-2011 08:50 AM |
Sent emails all have same date/time?? | Confused | Outlook | 3 | 01-07-2011 07:52 AM |
Word 2007 date and time picker | dmcohio | Word | 2 | 04-09-2010 04:13 AM |
Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |