Pursuing big religion teach how to convert excel to commas TXT-CodePudding

Home > Software engineering > Pursuing big religion teach how to convert excel to commas TXT

Pursuing big religion teach how to convert excel to commas TXT

Time：09-27

As title, and under the great god told code, how to make a excel automatically converted into a comma-separated list of TXT ah, thank you

CodePudding user response:

The file save as CSV file.

CodePudding user response:

XlBook. SaveAs "d: \ chenjl1031 CSV," xlCSV
Then change the CSV to TXT.

CodePudding user response:

reference 1st floor chenjl1031 response:

to file save as CSV file.

+ 1