I have this code to process from a directory all the xls and xlsx and convert them to txt delimited columns and works fine:
However I want to convert to txt delimited columns only from each file processed the sheet called “DATASHE21”. Inside each file I have a lot of sheets but I want that one only converted to text. Now the script what does is convert to tax delimited columns the first sheet but I don’t want that. I want only converted the “DATASHE21”. What would be needed to modify in the script for that?
Please, replace this code part:
with this one:
If you have better answer, please add a comment about this, thank you!