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

Blogs

  • New content on my site about 2010

    Hi all I create a 2010 section on my Tip index page with the first pages about 2010. http://www.rondebruin.nl/tips.htm Load different RibbonX when opening file in Excel 2007 or 2010 Download to find the names of the Excel 2010 ControlIDs (819 kb) Backstage view in Excel 2010 I not say they are good but this are my first examples that I [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Dec 20 2009
    Filed under:
  • Volume Activation Tips and Tricks

    Hi again, I’m Ted Way, program manager for Office 2010 volume activation . Last time I posted to this blog, I talked about KMS and MAK as two activation methods for the enterprise. If you’re planning on deploying Office 2010, Windows (7, Vista, Server 2008 R2, Server 2008), or a combination of these, you’ll be happy to know that the activation technologies are essentially the same. The same KMS host running on Windows Server 2008 R2, volume editions of Windows 7, or Windows Server 2003 can activate...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Fri, Dec 18 2009
  • Pasting Excel Ranges in Outlook

    When I copy and paste this Excel range into an Outlook email, it doesn’t look so good. I thought I would use JoinRange to put some tabs in between the text. I used a function like this =PERSONAL.XLS!joinrange(A2:D2,CHAR(9)) A tab is ASCII code 9. It will show up as squares in Excel but will turn into real tabs [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Dec 16 2009
    Filed under:
  • Office 2010 File Validation

    Howdy, I’m David B Heise and I work on the Office Security team responsible for testing Office File Validation (codename: Gatekeeper). There have been some misconceptions about the new file validation feature in Microsoft Office 2010 and I hope to clear these up and explain the why and what. Why Validate Binary Files? Throughout the years the office binary formats have necessarily evolved and grown in scale and complexity. The reasons why the formats are complex have been discussed sufficiently elsewhere...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Wed, Dec 16 2009
  • 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...
    Posted to The Excel Team Blog by Microsoft Excel on Tue, Dec 15 2009
    Filed under:
  • Office 2010: Visuals and Branding

    Hello, I’m Keri Vandeberghe and I work in Microsoft’s Office Design Group (ODG) as a User Experience Designer. I would like to share the story behind the visual approach and brand integration for Office 2010. I’ll give you a behind the scenes look at the philosophy that led us to the current design direction. Philosophy Office 2010 is not a complete makeover but a visual refresh to refine surfaces and remove unnecessary visual elements so the focus is on users’ content and less on the borders and...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Fri, Dec 11 2009
  • 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...
    Posted to The Excel Team Blog by Microsoft Excel on Thu, Dec 10 2009
    Filed under:
  • Multiple Substitute VBA

    In regard to Multiple Substitute Formula, here’s one way to do it in VBA. Sub RemoveStates()         Dim rInput As Range     Dim rStates As Range     Dim vaInput As Variant     Dim vaStates As Variant     Dim i As Long, j As Long     Dim sTemp As String         Set rInput [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Dec 10 2009
    Filed under:
  • Multiple Substitute Formula

    MaryAnn asks an interesting question. In column A there is text that may or may not contain the name of a US state. In column B there is a list of US states. In column C, we want the column A text without the state names. I think this would be a pretty [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Dec 9 2009
    Filed under: ,
  • Digital Signitures in Office 2010

    Hello, my name is Shelley Gu and I am a Program Manager on the Trustworthy Computing Security team. I’d like to introduce some new features we have added to digital signatures in Office 2010. First I’ll briefly explain what digital signatures are and how to use them, and then I’ll dive into the details about how they work in Office 2010. What are digital signatures? More and more business transactions are being conducted electronically. Consequently, digital signatures are being used increasingly...
  • Preventing auto_open and Workbook_Open events from running

    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. With Excel 97 to 2003, this was simple: hold the shift key when you click “Enable macros”. With Excel 2007 and [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Dec 7 2009
    Filed under: , , , ,
  • Formula Tokenizer

    A few years ago, I wrote a Formula Formatter add-in to present a long formula for easier reading. It does it through a process called Tokenizing, which is basically a process of putting the components of a formula into labelled boxes. That add-in was compatible with Excel 2003 formulas, but Excel 2007 brought us extra formulas [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Dec 5 2009
  • Office 2010 Beta Hits a Milestone!

    You may have already heard, but we have some exciting news from the Office team -- earlier this week we reached the 1 millionth download of Office 2010! This means that more than 1 million people across the world are now experiencing and testing the next version of Office. You’ll recall we launched the public beta just two weeks ago at the Professional Developer’s Conference and in reaching the 1 millionth download milestone, Office 2010 has had more people download it in the first two weeks than...
    Filed under:
  • VSTO Online Support for Developers

    Microsoft has recently revamped the VSTO online learning center which looks very good to me. The site provides information and knowledge about VSTO and how to use it to develop Excel, Word and Outlook solutions and also how to deploy the solutions. From my point of view it’s welcoming as I know that many developers [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Thu, Dec 3 2009
  • Minimizing the Ribbon: Exposed

    It’s Jon again from the Office User Experience team. I started at Microsoft a little over 2 years ago and one of the things that inevitably happened is that I instantly became the IT guy for everyone I know. The nice part about this is that every now and then I get to show off something that’s really cool to impress everyone in the room. When I get asked about Office 2007, an interesting trick I like to mention is the ability to minimize the Ribbon by double clicking on the active tab, pressing Ctrl...
« First ... < Previous 63 64 65 66 67 Next > ... Last »
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.