Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: MS Office 2010 - Word Macro

18 May 2016   #1
G8T3R

Windows 7 Enterprise x64
 
 
MS Office 2010 - Word Macro

I am a novice at this and I have searched and searched over the last week trying to figure out a fix to this.

I'm trying to create a Word Macro to remove time from date:

This occurs in 4 different cells.

Cell in Word shows: 05/04/2016 10:00:00

I just need the date to show without the time.

Looking for a code that will make this happen.

Code that I have used for other issues looks something like this, however, the below example is what I'm trying to accomplish:
________________________________________________

Sub TIME()
'
' TIME Macro
'

With Selection.Find

.ClearFormatting
.Text = "??:??:??"
.Replacement.ClearFormatting
.Replacement.Text = ""
.Execute Replace:=wdReplaceAll, Forward:=True, _
Wrap:=wdFindContinue


End With

End Sub
________________________________________________

Any help would be greatly appreciated!



My System SpecsSystem Spec
.
18 May 2016   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Hi & welcome to the Forum.

Instead of using a macro for adding the date you can use Alt+Shift+D instead.

This website may also help you as well.

How to Add the Date and Time to a Word 2010 Document - For Dummies
My System SpecsSystem Spec
23 May 2016   #3
G8T3R

Windows 7 Enterprise x64
 
 

Hey,

We have a form that we created that pulls 3 different dates, in which something has occurred.
We created this form from a preconfigured XSD file.

This XSD file is configured to pull data from a SQL Database.

We need only the date to show up, not the time.

So we trying to figure out a quick fix to this to only show the date.
My System SpecsSystem Spec
.

23 May 2016   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Sorry, I can't help you with that.

Perhaps someone else will drop & help.
My System SpecsSystem Spec
Reply

 MS Office 2010 - Word Macro




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Where is Office 2010 Word Template Folder?
According to the site below and a few others, the template folder is at BET: Microsoft Word Templates - Normal.dot C:\Documents and Settings\"user name"\Application Data\Microsoft\Templates\ I'm using Windows 7 64 bit and there is no Document and Settings Folder in Windows 7. I can't...
Microsoft Office
Create a Date macro Word 2010
I'm having trouble creating a macro to insert the current date (static). Here's what I'm doing: View > Macros > Record Name: "Date" Store macro in: keyboard Shortcuts Click on keyboard picture Insert: CRTL+D & click Assign
Microsoft Office
MathType for word 2010 Macro settings error
Hello, I have Microsoft Office 2010 32bit installed, I installed MathType 6.7 today, and I'm getting errors on macro settings. I've looked it up on google, and enabled macro settings, copy the necessary files, but the same errors keeps popping up. When I launch Word 2010 I get this:...
Microsoft Office
How to insert a Macro into Word 2010 in Windows 7 & Assign Shortcut
I cannot find up to date, step by step instructions on creating a macro in Word 2010 on Windows 7. While in Word, View, I see Create Macros. And I can name it and paste in this info below. Sub PrintCurrentPage() Application.PrintOut Range:=wdPrintCurrentPage End Sub But how do I assign a...
Microsoft Office
How to convert MS xps documents to Word in Office 2010?
Hello all, I have Office 2010 installed. I often print an online news article to the xps format. Sometimes I have the need to convert this format to Word. The question is how do I make the conversion without using a free software. It is preferable to use a software that would retain the...
Microsoft Office
Where is User Dictionary - Office 2010-Word & Outlook?
Hello there, I have been trying to collect all of my back-up necessary files into my "My Documents" folder, so I don't have to maintain a list or archive of all the different locations of them. I can just backup or copy the Documents folder regularly and as needed. I would like to know...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:33.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App