Recent content by nscotty_2000

Thanks, but still no joy!

Does anyone know how to imcorporate this into the above code?: .Cells(F:F).NumberFormat = "mm/dd/yyyy"

Does anyone know how to imcorporate this into the above code?: .Cells(F:F).NumberFormat = "mm/dd/yyyy"

The replace code is updating a column header in the exported file. The header needs to be called "Deliv.Date" for import into another system but Access won't allow "Deliv.Date" as a Field name so it has to be replaced on export. Can I use something like this to format that specific column...

Thanks, but CurrentDate is only used to name the excel file. It's not used for the data inside the exported excel file?

Cheers, but I have changed all the regional settings to dd/mm/yyyy already and it still reverts back to mm/dd/yyyy in the exported excel file?

Hi, I have been searching through forums and cannot find an answer to my problem. I have all time/date settings on the machine set to dd/mm/yyyy. I have "Short Date" as the format for all date fields in Access and have also set the MS Office default settings to dd/mm/yyyy. However when creating...