Paste date / time via macro from Excel into Word

[adamprocter]

I am creating a word document from excel which is working great bar these 2 fields they are set in excel as Date and Time columns, which are originally generated from NOW() & TODAY()
The date seems to paste in almost ok (DD/MM) aka 11/06 but misses of the year and the time seems to paste in the sum or the unix date and not something understandable.
Am assuming I need to not copy the value but the adjusted text

  Set wdRng = wdDoc.Bookmarks("myDate").Range
    wdRng.Text = Sheets("my sheet 1").Range("Q65536").End(xlUp).Value
  
  Set wdRng = wdDoc.Bookmarks("myTime").Range
      wdRng.Text = Sheets("my sheet 1").Range("P65536").End(xlUp).Value

any help much appreciated.

 

[Domenic]

Try...

  Set wdRng = wdDoc.Bookmarks("myDate").Range
    wdRng.Text = Format(Sheets("my sheet 1").Range("Q65536").End(xlUp).Value, "dd/mm/yyyy")
  
  Set wdRng = wdDoc.Bookmarks("myTime").Range
      wdRng.Text = Format(Sheets("my sheet 1").Range("P65536").End(xlUp).Value, "h:mm AM/PM")

Change the formats as desired.

Hope this helps!

 

[adamprocter]

worked like a dream thanks

 

[Domenic]

You're very welcome!