DATE reversed when run Paste Special by VBA code

[Hyakkivn]

Hi everyone !
As the title, I got problem with paste special function when I copied data (table type) from 3rd party software (wrote in VB.net language with DATA store to an Access file) to excel.
Everything went well until it copied date. For example, the date is: 08 Oct 2021 (08/10/2021), after copy and paste special by macro, it become 10 August 2021 (10/08/2021)
But if I do it manually (Ctrl+C at software then right click and choose Paste Special on Excel), nothing wrong with that date.
Any help will be appreciated.
Best regard !!!

 

[jasonb75]

All I can do is do copy paste special manually.

See posts 2 and 4

 

[RoryA]

It means that whatever is on the clipboard is text, not a true date value. You'd have to amend the code you have.