title: Running a macro from the command line on a file that exceeds excels row/column limit
body: <p>I have been using a useful VB script that goes through a spreadsheet row by row, checks for duplicate cells in that row, deletes all the duplicates and shuffles all the cells along so there are no blanks.</p>
  
  <p>It looks like this:</p>
  
  <pre><code>Sub StripRowDupes()
    Do Until ActiveCell = ""
       Range(ActiveCell, ActiveCell.End(xlToRight)).Select
       For Each Cell In Selection
          If WorksheetFunction.CountIf(Selection, Cell) &gt; 1 Then
             Cell.ClearContents
          Else
          End If
        Next Cell
        On Error Resume Next
        Selection.SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft
        ActiveCell.Range("A2").Select
     Loop
  End Sub
  </code></pre>
  
  <p>However, I now need to perform the same operation, only on a CSV file that has 48,051 columns and therefore wont load in excel due to its 16,000 column limit. </p>
  
  <p>Can I run the script from the command line on the file?</p>
  
  <p>How could I go about doing this?</p>