PROBLEM 1: "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." SPECIFICATIONS:
PROBLEM 2: "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" SPECIFICATIONS:
|
Parse Functions >