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. […]
Monthly Archives: December 2009
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.
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 […]
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.