See, for example: https://www.msofficeforums.com/151706-post25.html
and especially the revised version of the document in: https://www.msofficeforums.com/151784-post33.html
Have you actually done any research on any of the topics you've started? There are many examples of code for this one, for example, readily available on the web.
Cheers
Paul Edstein
[Fmr MS MVP - Word]
Which is essentially what was advised here: https://www.tek-tips.com/viewthread.cfm?qid=1819384 - and with links to VBA solutions if needed.
Cheers
Paul Edstein
[Fmr MS MVP - Word]
See, for example:
https://www.msofficeforums.com/158713-post3.html
https://www.excelforum.com/word-programming-vba-macros/1314685-need-help-to-browse-by-file-msofiledialogfilepicker-instead-by-folder.html#post5323754
The code in both those threads will generate an output document that shows what...
All you need for that is a simple Find/Replace, where:
Find = /
Replace = /
And you set the replacement font attribute to bold. You could even change the colour if that aids visibility.
Cheers
Paul Edstein
[Fmr MS MVP - Word]
Simpler:
With wordDoc.Tables(4)
For r = .Rows.Count To 1 Step -1
If Split(.Cell(r, 1).Range.Text, vbCr)(0) = "X" Then .Rows(r).Delete
Next r
End With
Cheers
Paul Edstein
[Fmr MS MVP - Word]
Given the inherent difficulties in exporting Word math objects to other apps, I'd suggest doing the lot in Word. If needed, you can use a second document with a table into which you can copy/paste content from your primary document and use that much as you might use Excel.
Cheers
Paul Edstein...
I would recommend against that approach, since exporting content to a text file would be liable to both delete unsupported characters and whatever formatting you have. If you need the content in Excel, you would do better to export it directly to an Excel workbook. You could, of course, simply...
It's not at all clear to me how any comparison could be done except visually, which means going through them one-by-one. Your best option would seem to be to use a split window so you can compare, say, a math object in one window with whatever references it in the second window.
That said, it...
A macron is a diacritic ¯ placed over a vowel. It is usually used in pronunciation guides as an indication that the vowel has a long sound. A vinculum is a bar ¯ placed over any letter or number. It is used in mathematical notation, most commonly to indicate a repeating decimal. Some fonts...
The default US date output format is irrelevant. If you need a different format, you really should learn to use mailmerge field switches. See my Mailmerge Tips & Tricks page: https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
Cheers
Paul Edstein
[Fmr MS MVP - Word]
If if someone has entered dates in the wrong format for the workbook, especially if they've dome it for some dates and not others, there is no reliable way of correcting it via field coding or even vba. In other words, manual intervention will likely be required. Hence, your D/M test risks...
You really don't seem to have paid attention to what I wrote about not needing to test the day/month. All you should need is:
{SET MDATE {MERGEFIELD FLDNM}}{=INT(({MDATE \@ D}+INT(({MDATE \@ M}-986/1000)*30.575)-{={MDATE \@ M}> 2}*(2-{IF{=MOD(10;10)}= "!*" {=MOD({MDATE \@ yy},4)=0}-{=MOD({MDATE...
Not really, since the ultimate goal seems to be to generate the output in a mailmerge. A UDF would require much more effort to deploy in that context.
Cheers
Paul Edstein
[Fmr MS MVP - Word]
That is because your system uses non-English regional settings, which is why I provided the second field code to handle both English and non-English settings. There is no need for anyone to change their regional settings or edit the field code if you take that approach.
Cheers
Paul Edstein
[Fmr...
The fundamental problem with your first field is that it uses an en-dash (–) instead of a minus sign/hyphen (-) for the 2nd subtraction. In any event, that field code could be reduced to:
{=INT(({DATE \@ D}+INT(({DATE \@ M}-986/1000)*30.575)-{={DATE \@ M}> 2}*(2-{=MOD({DATE \@...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.