Skip to content

Monthly Archives: December 2009

Online Backup for Mac (Mozy, Carbonite, iDrive, Dropbox, ...)


Trying to find out a way to backup my data online. Lots of options. Most of the "unlimited" backup plans have a caveat: Mozy -- Free account of 2 GB. Deletes permanently deleted files after 30 days. Carbonite -- Deletes permanently deleted files after 30 days. Backblaze -- Deletes permanently deleted files after 4 weeks. […]

[Google Analytics] Track to Two Profiles the Async Way


The new asynchronous tracking in Google Analytics requires new code as well. If you need to track more than one profile, this is how you do it.

[Excel] Recalculate Sheets on Workbook Open (Using VBA)


Add to ThisWorkbook->Workbook code. Private Sub Workbook_Open() Dim oSht As Worksheet Dim xlCalc As XlCalculation On Error GoTo ErrorHandler 'remember the user's calculation setting before setting it to manual xlCalc = Application.Calculation Application.Calculation = xlCalculationManual For Each oSht In Worksheets oSht.EnableCalculation = False oSht.EnableCalculation = True Next oSht Application.Calculate ErrorExit: On Error Resume Next 'restore […]

[Outlook] Remove Attachments (Bulk/Batch): Use VBA


Had to remove attachments from a bunch of emails. This VBA code did the trick (although it does not know how to handle attached emails, i.e. emails that have another email attached). (Remembe to create a reference to the Microsoft Scripting Runtime library: in VBA choose Tools -> References and check its checkbox.) Option Explicit […]

[Excel] Days in Month


=DAY(DATE(YEAR(A1);MONTH(A1)+1;1)-1) , where A1 contains a valid date.