Thread: [Solved] Using VBA to convert Excel serial date to Mail Merge Date format
View Single Post
 
Old 11-19-2025, 08:17 AM
Rudy Rudy is offline Windows 10 Office 2021
Novice
  
Join Date: Jul 2023
Location: Liverpool, England
Posts: 2
Rudy is on a distinguished road
Talking Solved it lol
Turns out I didn't need anything too fancy, seems like VBA is happy enough with me forcing a date format like this

Code:
DOR = oXL.ActiveWorkbook.Worksheets("Docvariables").Range("E3").Value
DOR = Format(DOR, "dd/mm/yyyy")
ActiveDocument.Variables("DOR").Value = DOR
Reply With Quote