Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Delete columns in a csv file
Here is how i have edited your code.. what i am doing wrong... because it is not deleting the columns i want deleted 'On Error Resume Next Dim objFSO, dataArray, clippedArray() Set objFSO = CreateObject("Scripting.FileSystemObject") 'Create an array out of the CSV 'open the data file Set... -
Delete columns in a csv file
This is cool i was wondering what if i wanted to delete more then one column at a time say i wanted to delete columns 6,7,9,32,67,99 how would you add this to your script? including the If intCount <> CutColumn -1 Then change
