| Button to insert date Posted: 23 May 2013 09:20 AM PDT Context: I have created a tab with various commands groups, mostly from macros. My objective are to achieve standardization of the content input and that novice users can fill a word document matrix with little or no knowledge of Word and tables. The date must be that of the day of the input of a row, not that of the document creation.
The predefined formats (Insert tab, text group, date and time) are not suitable so I used the field Date when I recorded the macro. I tried to do Ctrl+Shift+F9 but the macro did not record that command.
What code do i need to add to my VBA to insure that the date is "unfielded" once created? I tried the following but it does not work...
====================
Sub InsérerDate()
'
' InsérerDate Macro
'
'
Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, Text:= _
"DATE \@ ""dd/MM"" ", PreserveFormatting:=True
Selection.Fields.Unlink
End Sub
=====================
Thank you!
|
| What?? Documents can be stored only on phone,not on SDCard?! Posted: 23 May 2013 08:12 AM PDT What?? Documents can be stored only on phone,not on SDCard?!
Someone of really low intelligence works there in Redmond on this part of Microsoft planetary system to make such unintelligent decisions. |
| Keeping Change Line Posted: 23 May 2013 07:22 AM PDT I have a Word 2007 Document that I am reviewing with Tracking Changes turned on and a line on the right side indicating the changed line or graphic. When the document is finished I want to be able to accept all changes but keep the right side line visible to the reader. How do I do this? |
| Office Home & Student 2013 word, Excel PWP impossible to modify the colour of text with word, text and background in excel and pwp. Posted: 22 May 2013 10:21 PM PDT Office Home & Student 2013 word, Excel PWP impossible to modify the colour of text with word, text and background in excel and pwp. |
| When I try to change the font to print an envelope in Word, it will change for the delivery address, but won't for the return address. Why not? Posted: 22 May 2013 05:47 PM PDT I have Office 365 and I am trying to change the font to print an envelope, but it will do it for the delivery address, but the font won't change for the return address. |
| If I stop typing before the end of a page I can't scroll down to next blank page Posted: 22 May 2013 05:07 PM PDT I am on page 201 of my book. Usually I can go right on to the next chapter by just scrolling to the next blank page. Just like I do in the middle of a chapter. Now, I finished a chapter and it won't let me just continue. How does it know I finished a chapter? I scroll to the bottom of the page and it won't move from there. Any ideas? |
| Internal links in Word2010, just like in Excel. How to? Posted: 22 May 2013 02:19 PM PDT I work with Word templates where the same informationen is repeated various places in the document. I wanted to be enter the information only in one place, and have the entry automatically displayed throughout the document. Just like the referencing in Excel. How to do it in Word? Any good ideas?
Thanks in advance! |
| Trouble getting rid of upside down T character - AutoFit related Posted: 22 May 2013 01:43 PM PDT I notice an odd character (an upside down T) appears in the table cells I've formatted. I found out that these marks are because of the enabled AutoFit setting. The marks disappear when AutoFit is turned off but I need AutoFit for my table. The character cannot be deleted as it is attached to the text. Any suggestions on how to get rid of this character? Thanks, Alissa |
| Changing case of merged information in Word 2007. Posted: 22 May 2013 09:02 AM PDT I am trying to format names and addresses in Word 2007 that were mail merged from MS Access. I have tried adding \* FirstCap at end of merged field, but does not seem to work. Any suggestions? |
| Is There a Way to Reduce the Vertical Spacing between Checkboxes? Posted: 22 May 2013 09:00 AM PDT I'm trying to replace ActiveX checkboxes with Form Checkboxes in an existing template for speed and compatibility. The checkboxes are stacked vertically with a cell of a Table and pretty closely align with lines of text in the adjacent cell. The problem is that when I stack the Form Checkboxes they seem to take about 50% more vertical space than the ActiveX, even thought the checkbox symbol itself is the same size. Is there any way to stack these closer together? (Through search I found some techniques using symbols and macros; however I'd prefer a solution that doesn't require macros). We are using Office 2010 and the file is .docx format. Thanks in advance! - Jerry |
| Add bing to research options Posted: 22 May 2013 01:22 AM PDT Hi there everyone.
I currently have MS Office 2010 installed and at the school computers at school they have under the research/look up options Bing. Currently on my MS Office 2010 programs there is no such option or way to add this. I have tried the add service screen and have typed in "http://www.bing.com" but at has showed up that their is no such service. Can somebody please show me how to add bing to the research options!
|
| Save As HTML, now all .docx files open with messed up formatting Posted: 21 May 2013 01:02 PM PDT Word 2013. I used Save As to create an HTML version of document. When I opened the .htm file, the formatting was messed up, which I expected (the file used columns). But, when I open the original .docx file, the formatting is messed up in the same way as the .htm file-- yet Windows Explorer says that the original .docx file has not been modified since several days ago. My original file is not actually changed. But Word is not displaying it correctly. I TRIED OPENING MY OTHER FILES, AND THEY'RE ALL MESSED UP TOO. It doesn't matter how I open: double-click in File Explorer, or File>Open in Word. I've made sure not to save any files. Also, if I use File>New to create a new .doxc file using the template on which my original .docx file is based, the file looks right initially -- before I save it. But if I save it, close it, and reopen the brand new .docx file-- the formatting is messed up, just like the .htm file. |
| Macro Word: Highlight text then add following "QUOTE" Field Posted: 21 May 2013 10:51 AM PDT I am a total newbie at VBA, and hitting a snag, so be gentle!
I am working on the following scenario for Word 2010:
I am trying to highlight selected text within the active document then insert a QUOTE field code with data based on input from a userform.
Invoking the userform, highlighting, and inserting of field work, but I cannot figure out how to turn off the highlighting before inserting the field code.
Any advice would be greatly appreciated!
HL
The relevant code (partly from recording macros, partly from research, and partly trial and error) is:
Private Sub cmdOK_Click()
Dim abbrType As String
Dim abbrMark As String
Dim expan As String
Dim entered As String
Dim insertMe As String
Dim oRng As Range
Dim oInsertAft As Range
Set oRng = Selection.Range 'range of selection
<snip ...>
'output to document
'highlight abbreviation itself
oRng.HighlightColorIndex = wdYellow
Set oInsertAft = oRng
oInsertAft.Collapse wdCollapseEnd
oInsertAft.HighlightColorIndex = wdBrightGreen 'stuck this in just to see if it altered the formatting
'Put other data in field: concatenates strings from userform
insertMe = expan & "[" & abbrType & "&" & abbrMark & "]"
oInsertAft.inser
Selection.Fields.Add Range:=oInsertAft, Type:=wdFieldEmpty, Text:= _
"QUOTE "" " & insertMe & " "" ", PreserveFormatting:=False 'shouldn't this not continue the earlier highlighting?
<snip ...>
End Sub
|
| Adding Paragraph numbers in headers Posted: 21 May 2013 09:34 AM PDT I am creating a new document that contains Rules that are numbered. I need to reference the first Rule number in the header. For example, page 1 has Rules 1, 2 and 3, and so I need to have " Rule 1" in the header on page 1. Page 2 starts with Rule 4 and so that would appear in the header.
I don't even know how to begin.
Also, I need to tag the Rule No for inclusion in the Table of Contents.
Help!!!!
|
