Forum Discussion
Dates are not correctly populated from word to excel
How do i resolve the following issue below? The original file is in pdf and i have a macro to convert the pdf file to word docx. I have got another macro to extract data from word to excel. T...
On the quick and at first glance without having tried it,
remove the apostrophe (') from the number format lines.
Example:
instead of
'wsD.Range("C18").NumberFormat = "dd/mm/yyyy"
without an apostrophe
wsD.Range("C18").NumberFormat = "dd/mm/yyyy"
..remove from all number formats.
NikolinoDE , tried previously, it didn't work either. I am going to share the files here, see whether are the dates populating correctly at your end.
