Auto Create a tab-delimited (.txt) file from a spreadsheet

[Don Beam]

need to create a tab-delimited file based on a spreadsheet .. with no manual intervention to create it.

Titles in first row
No more than 5 columns and 50 rows..

Sample spreadsheet attached

Force the creation of the tab file to occur on ss exit.

Any thoughts would be appreciated .
SS_Convert.jpg

[maniacb]

Place this code in the Workbook module and the file will save automatically as a tab delimited csv file before closing. Excel does not support saving in a tab delimited txt file format. See MSLinK

Please Login or Register  to view this content.