Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Nick Hodge's Excel Blog » All Tags » Excel 2007 (RSS)

Browse by Tags

  • Office 2007 SP2 Released

    Office SP2 has been released officially here . The list of changes against Excel seems fairly small but having been running the beta for some time it does seem quite a bit better, additionally there are improvements across the suite, probably most noticeably the speed in Outlook. Additionally support has been added for the Open Document Format (ODF) which is 'compatible' with stuff like Google Documents, although there are some areas where that just doesn't work, but expect that to get...

  • Today's Large Data Set

    Now, since Excel 2007 was announced to be having over 1 million rows, I made the statement, "Be careful what you wish for". Excel is not a database, there are programs far more suited to that task such as Access, SQL Server, SAP, Oracle, etc. Excel is a great reporting tool for those databases and can do fast and quite complex calculations much better than a database can. What I am conceding more and more now though, is that as my familiarity with Excel is far greater than with SQL Server...
    Filed under:

  • Excel 2007 - Getting External Data

    On of the most visited parts of my web site is the part on external data. Most of it was based on Excel 2003 and before, so I thought I should update it for Excel 2007. INTRODUCTION The first thing you will notice about 2007 is the ease in which you can find the data 'movement' tools. Now, say what you think about the ribbon in Excel 2007, but finding where to import and export data is not one of them! It's on the Data tab. (as below) I have only shown you the section above. The tab extends...

  • Questions on customising the ribbon

    I have, via the blog contact form received three questions from Milan, these were Can you remove the Office Button? Can you link a combobox (on the ribbon) to a cell/range? Can you link a label (on the ribbon) to a cell? The answer to No.1 was answered in the 2nd of my series on customising the ribbon. In the section under Full Dictator Application. No. 2 is yes you very much can but it is not a simple process like having a 'link' property or similar. The write-up below demonstrates how you...

  • Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

    So we've explored the file formats, created the shell for a dictator application, made some basic ribbon, tab, group and control changes and customised the Office menu. We've re-purposed some Microsoft controls to our own use and now we will be running at pace through some of the other controls available to you. I doubt we will cover all of them, but you can download a bunch of my files here , which demonstrate more of what you are learning here and also contain a 'popular' control...
    Filed under: , ,

  • Ribbon, Step-by-Step. Part 3 (The Office Menu and Re-purposing)

    In our first two parts we covered the file structure of Excel 2007 and some very simple customisations which, in the main, do not require any VBA code. in this part we are going to try and accomplish two things. Customisation of the Office Menu (under the office button) Re-purposing built-in controls to do other things. In the next one or two parts we will cover more details on the various controls, including Galleries and Contextual tabs and then how we can capture the ribbon object and change controls...
    Filed under: , ,

  • Ribbon, Step-by-Step. Part 2 (Begin Customisation)

    In the last part of this series , we went through the different file formats as a precursor to starting Ribbon customisation. You should by now have downloaded the Office 2007 Custom UI Editor , as this is the tool we will be using to customise our RibbonX and generate callbacks for VBA. We'll start with a run down of the tool itself. Remember, you need to have the .Net 2.0 framework, or above loaded on your development machine. The Office 2007 Custom UI Editor Without worrying too much about...
    Filed under: , ,

  • Ribbon, Step-by-Step. Part 1 (File Formats)

    I am going to endeavour to enthuse some more people into development of the new ribbon in Excel 2007 (well other applications too, but I will use Excel throughout). You will need a knowledge of XML and VBA, as these are the two technologies I will be using. I suspect it will take about 4 or 5 'sessions' to get up to some kind of understanding and I intend to cover the following: File Formats Dictator Applications Custom Tabs and the Office Menu Using Built-In Groups and Controls Using Custom...
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.