Tag Archives: Excel 2013 preview

Excel 2013 Preview: New Worksheet Functions

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

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

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

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