"I have a workbook with 30 sheets, and I need each individual sheet saved as a delimited text file (delimiter is tab) in the same folder as the excel file, named after the name of each corresponding worksheet. Eg. Worksheet name is "B", then I need all the content of the worksheet saved in file B.txt with delimiter tab. once that sheet is done, move on to the next sheet. However, there are 3 exceptions of sheets which I do not want to be processed: "A-K" or "L-S" or "T-Z". Al other sheets shall be processed."
"I have a worksheet with many columns of data. I need to create a comma-delimited text file with the values from columns A, B and C only"
Parse Functions >