Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2015, 05:15 AM
TechieHell TechieHell is offline Word signatures w/ date stamp Windows 7 64bit Word signatures w/ date stamp Office 2007
Novice
Word signatures w/ date stamp
 
Join Date: Mar 2015
Posts: 2
TechieHell is on a distinguished road
Default Word signatures w/ date stamp

Hi all,



I was wondering if I could call on your collective intellect.

A user of ours is looking for a method to create a text field in Word in which a person can type their name, and a time/date stamp is automatically added.

This is going to be used as a method for digital signatures, to save printing, using a pen to sign the doc, and scanning it.

I've had a play with track changes but concluded that macros would be the way, as apparently the person had used them for that in a previous job.

Macros might as well be in Klingon to me though, so any help would be absolutely pukka.

Cheers

Last edited by Charles Kenyon; 03-16-2015 at 08:04 AM. Reason: Mark as solved
Reply With Quote
  #2  
Old 03-16-2015, 05:53 AM
gmayor's Avatar
gmayor gmayor is offline Word signatures w/ date stamp Windows 7 64bit Word signatures w/ date stamp Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can certainly insert the username, time and date into a document using VBA, though it would have no security value.

Code:
Sub InsertNameAndDate()
    Selection.TypeText Environ("UserName") & Chr(32) & Chr(150) & Chr(32) & _
                       Format(Date, "Long Date") & Chr(32) & Chr(150) & Chr(32) & _
                       Format(Time, "HH:MM")
lbl_Exit:
    Exit Sub
End Sub
You could include a scanned signature graphic, but that would not improve security either, and you would need to arrange a selection of images one for each user.

This is not a substitute for digitally signing a document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-16-2015, 07:24 AM
TechieHell TechieHell is offline Word signatures w/ date stamp Windows 7 64bit Word signatures w/ date stamp Office 2007
Novice
Word signatures w/ date stamp
 
Join Date: Mar 2015
Posts: 2
TechieHell is on a distinguished road
Default

Thank you my friend- that is just what I was looking for!

I've let them know that it isn't too secure, but it's made them happy so my work is done.

All the best
Reply With Quote
Reply

Tags
macro, signature, word 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word signatures w/ date stamp Eliminate time stamp in Track Changes Aden Word 19 07-10-2023 09:02 PM
Word signatures w/ date stamp Updating time stamp only when changes have been made and re-saved ashmo0024 Word 1 09-05-2014 01:46 PM
Outlook 2003-formatting vba Date stamp Royzer Outlook 0 03-29-2012 10:39 AM
Word signatures w/ date stamp Signatures rob75 Outlook 3 05-18-2011 05:02 PM
Add date and time stamp to new mail and incoming mail cadsmarter Outlook 0 02-02-2006 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft