Skip to content

Category Archives: Software

Create Favicon (Multiresolution) on OS X


IcoMaker, it works. "On the mac, this is a snap, thanks to Takeshi Ogihara’s IcoMaker. Head over to his page (assuming it’s a he), and look for the link at the bottom of the page, something like: “IcoMaker Distribution Package, 84KB”." via steve cooley presents » Blog Archive » HOWTO: create a favicon.ico on Mac […]

Line Break in Excel Header / Footer via Macro


Using VBA, add line break to header or footer with Chr(13). E.g. ActiveSheet.PageSetup.LeftFooter = "Foo bar" & Chr(13) & "Another line"

[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.