Thread: [Solved] Using VBA to convert Excel serial date to Mail Merge Date format
View Single Post
 
Old 11-22-2025, 09:37 AM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,636
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
Seems this should work as well:


Code:
ActiveDocument.Variables("DOR").Value = Format(oXL.ActiveWorkbook.Worksheets("Docvariables").Range("E3").Value, "dd/mm/yyyy")
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote