what does that mean: in csv file can we use the macro to copy & paste ?
to me it looks like any vba code inside csv file, like generate vba from vba to csv
usually file with vba is a .bas file (also in text format, which not means it must be open in notepad)

I generated csv with the result like you want, it could be open in Excel with data format you want. Of course I did it without vba so Alan will be better to create vba for this

if you want csv , generate the result you want by vba in Excel then use vba to save this excel as csv