Consulting

Results 1 to 2 of 2

Thread: Touch/convert/modify Creationdate

  1. #1
    VBAX Newbie
    Joined
    Dec 2019
    Posts
    1
    Location

    Touch/convert/modify Creationdate

    Hi...

    i have a problem...

    we have 12k RTF-Files who want to be converted to DOCX... (12k Files RTF=16GB, DOCX = 650MB). In the Files is a Autodate Field...

    My Questions:

    1. This Field needs to be changed to Creation Date - this is no problem... But how can i change the format of this?

    Set rngTemp = ActiveDocument.Fields(1).CoderngTemp.Text = " CREATEDATE "
    ActiveDocument.Fields(1).Update
    2. Is it possible and how to use creation Date from the RTF and save it to the new DOCX?

    Is there anyone who had this problem already and can help me with this?

    Thanks in advance

    toddel

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    For example:
    With ActiveDocument.Fields(1)
      .Code.Text = "CREATEDATE \@ " & Chr(34) & "dddd, d MMMM YYYY" & Chr(34)
      .Update
      '.Unlink
    End With
    If you want to 'lock in' this date, you need to run the macro before doing the conversion and activate the commented-out '.Unlink line. Otherwise, the SaveAs you'll need to do will reset the
    creation date.
    Last edited by macropod; 12-09-2019 at 02:14 PM.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •