VB Script Excel to CSV file

[xerouk]

Hi guys,

I am trying to scan a excel file and save the required rows to a csv file. I am able to manipulate and search the data but cant find a way to delete a row from a excel file using a vb script or bypass a row and still copy the others.

Thanks

 

[namnoc]

Hi, if you load all the data into an array you can simple select the elements you want to output to the csv file. Does that makes sense, or have I missed what you want to do? Email me at [email protected] if you want a longer answer.