I am looking for a VB Script which read a and remove specific lines and columns of File1.csv defined in differents Array variables and generate a File1_revised.csv:
Ex of Array Variable:
linestoremove = Array(1,4,5)
columnstoremove = Array(2,8,6)
Afer I launch the script File1_revised.csv will be created and shouldn't contains lines 1,4 and 5 and columns 2,6 and 8 of File1.csv.
If someone can provide the pure VbScript approacch and the CreateObject("Excel.Application") approach it would be great!
Thank you in advance for your help!