Adding current time to VBA

		Microsoft Office Forums > Microsoft Word > Word VBA
Adding current time to VBA

01-13-2018, 02:40 AM

macropod

Windows 7 64bit Adding current time to VBA

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Quote:

Originally Posted by blackroz

Quote:

Originally Posted by macropod

You could just change:
strDate = Format((Date), "dd MMM yyyy")
to, say:
strDate = Format(Now, "dd MMM yyyy @ hh mm ss")

I added but it shows 00 00 00

And did you change:
(Date)
to:
Now
?

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

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
Table adding cells to previous page with room still on current page.	gedet	Word	1	01-03-2018 10:35 AM
adding and subtracting time on timesheet	renny0927	Excel	1	03-09-2017 01:07 PM
Automatically Delete Slides based on current time	Pacman52	PowerPoint	2	07-16-2015 05:30 AM
Create check box to insert current time	dougdrex	Excel	1	12-07-2014 07:52 PM
Current time keyboard shortcut	jbwenu	Excel	2	02-05-2013 06:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.