Skip to content

Monthly Archives: December 2009

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

29-Dec-09

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

15-Dec-09

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)

10-Dec-09

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

10-Dec-09

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

01-Dec-09

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