Monthly Archives: August 2012

Excel 2013 Preview: New Worksheet Functions

Posted on August 12, 2012 by Colin Legg

Most of the new worksheet functions were listed in the last post which looked at changes in the Excel Object Model. To complete the list, the new worksheet functions which aren’t exposed in the WorksheetFunction class are: FORMULATEXT() SHEET() SHEETS() I … Continue reading →

Posted in Microsoft Excel | Tagged , , | Leave a comment

Excel 2013 Preview: New Excel Object Model Members

Posted on August 7, 2012 by Colin Legg

I’ve cobbled together the below table of Excel Object Model members which have been introduced  between Excel 2010 (Office Professional Plus) and the Excel 2013 Preview (Office 365 Home Premium). Don’t worry, I didn’t spend hours manually trawling through the object browser to spot … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , | 3 Comments

Excel 2013 Preview: Microsoft Scripting Runtime Errors

Posted on August 4, 2012 by Colin Legg

One of the first pieces of VBA code I intended to write in Excel 2013 involved using a Scripting.Dictionary object. Unfortunately, subsequent to the Office 2013 installation, if I tried to create any object from the scrrun.dll library I got … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , | Leave a comment

Excel 2013 Preview: Installation and Ribbon Errors

Posted on August 1, 2012 by Colin Legg

The MS Office 2013 public preview was made available on 16th July and I’ve finally had a chance to get stuck in. The installation itself went very smoothly and I put trust in the fact that it would sit happily … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , | 3 Comments