How to Use VBA to convert the date format of text files

I used VBA to convert an Excel file to a file, but the date format in the converted text file is not the same as that in Excel, and the date format in Excel is, after the text format is converted, the date format is changed to 11/8/2008. The date format in the converted text format file remains unchanged from 2008 to 11-8. Thank you first.

 

Change a paragraph
Selection. Copy
Workbooks. Add (1)
With activeworkbook. activesheet
. Paste
For each cel in. Range (. [B2],. [b65536]. End (xlup ))
If isdate (CEL) Then cel. value = "'" & format (CEL, "yyyy-mm-dd ")
Next
End
Application. cutcopymode = false