nix, shell, perl, php, mysql and mac os x tips and tricks

Tuesday, September 28, 2004

VB to strip carriage returns from cells in an Excel file

Sub CleanUp()
Dim TheCell As Range
For Each TheCell In ActiveSheet.UsedRange
   With TheCell
   If .HasFormula = False Then
       .Value = Application.WorksheetFunction.Clean(.Value)
   End If
   End With
Next TheCell
End Sub

Monday, September 27, 2004

Burn a CD from cue/bin files on the command line

cdrdao write --driver generic-mmc --device 1,2,0 --speed 12 file.cue