Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. macropod

    Mail merge with details

    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
  2. macropod

    Run-time error '429': ActiveX component can't create object From Excel to Word

    The code in your first post employs early binding. Had you set a reference to Word via Tools|References in the VBA Editor?
  3. macropod

    Breaking the VBA Password in Access

    Kindly read: https://www.tek-tips.com/market.cfm Your request falls under Cheers Paul Edstein [Fmr MS MVP - Word]
  4. macropod

    How disable save and save as in word vba?

    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]
  5. macropod

    How compare 2 macros in vba 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]
  6. macropod

    Find different of word two documents in vba

    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...
  7. macropod

    Word 365: Find/Replace all "/" in a document to make them BOLD

    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]
  8. macropod

    Looping through a word doc to delete rows

    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]
  9. macropod

    Translate word document using VBA

    Cross-posted at: https://stackoverflow.com/questions/73907737/translate-word-document-using-vba Please read Tek-Tip's policy on Cross-Posting: http://www.tek-tips.com/market.cfm Cheers Paul Edstein [Fmr MS MVP - Word]
  10. macropod

    Looking for text/equation searchable word processor

    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...
  11. macropod

    Looking for text/equation searchable word processor

    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...
  12. macropod

    Looking for text/equation searchable word processor

    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...
  13. macropod

    Add a horizontal bar above a letter

    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...
  14. macropod

    Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)

    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]
  15. macropod

    Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)

    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...
  16. macropod

    Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)

    ...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 \@ yyyy},400)=0}+{=MOD({MDATE \@ yy},100)=0}...
  17. macropod

    Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)

    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]
  18. macropod

    Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)

    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...
  19. macropod

    Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)

    ...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 \@ yy},4)=0}-{=MOD({DATE \@ yyyy},400)=0}+{=MOD({DATE \@ yy},100)=0}))/7)+1 \# "KW00"} As for your 2nd...
  20. macropod

    Macro that unlinks the fields in a document, and then deletes itself

    Code revised. Cheers Paul Edstein [Fmr MS MVP - Word]

Part and Inventory Search

Back
Top