Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

December 2009 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Preventing auto_open and Workbook_Open events from running

    Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks. As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. This little article shows you how to achieve that...
    Filed under:

  • Daniel’s Extreme Lookup Collection

    Today’s author is Daniel Wiesenfeld, an Excel and Access Power User who is sharing his Extreme Lookup Collection with us so we can use the Excel User Defined Functions (UDFs) he created to enhance the lookup functionality. His web site daanalytics.com is currently under construction and should be available soon. In the Visual Basic Editor, insert a Module and paste the following code: ' XVLOOKUP (& XHLOOKUP) ' Works just like a vlookup (and hlookup) except that the user refers to a lookup...
    Filed under:

  • Introducing the JavaScript Object Model for Excel Services in SharePoint 2010

    Thanks to Christian Stich , a consultant working on Excel Services projects, for putting together this series on the Excel Services JavaScript Object Model. Excel Services 2010 has added two entirely new programming APIs: The REST API which I covered in an earlier series of posts and the JavaScript Object Model (JSOM) which I will discuss in this post. The JavaScript Object Model (JSOM) enables a whole new set of solutions using Excel Services. With the JSOM it is possible to detect and react to...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.