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

January 2008 - Nick Hodge's Excel Blog

Sort By: Most Recent | Most Viewed | Most Commented

  • 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...

  • Removing The Macro Security Warning

    Many times after macros have been recorded or written users want to remove them as they are no longer required, but they cannot get rid of the 'macro warning' pop-up that appears each time the workbook is open, (see below). (You should only follow these instructions if you have no further need for the macros or UserForms!) . Excel has the ability to put code in three places, ( see here ). If the code is in a standard module the key to stopping the dialog is to remove the entire module(s)...
    Filed under:

  • Importing Data with Parameters (ODBC)

    Using Parameters In External ODBC Data Queries Here we can demonstrate the linking of data in an external data source with Excel, using the values in cells to determine the data presented, using parameterised data queries. Open a workbook and on the active sheet in cells A1 enter Start Date and in B1 enter the date 01/01/2003. In A2 enter End Date and in B2 enter the date 02/02/2003. Take the menu options Data>Import External Data>New Database Query... You will fire from here a dialog asking...

  • Good publicity

    Via an MVP Lead at MS, we have got some very decent publicity, both here and in next month's edition of the Office Newsletter Good news and likely to increase traffic quite a bit

  • Video Files

    Just as a test, I have uploaded Part 1 of a set of videos dealing with Pivot tables in Excel 2007. This first one simply takes you though the new interface, using external data and shows some of the new features, like context-sensitive sorting and filtering, compact view, data connection management and live preview for themes. I hope to build this over time as a complete practicle reference on building Pivot Tables and it's features and benefits as I find them in my daily life. Hope you like...
    Filed under: ,

  • Reset Excel's UsedRange

    If you are frustrated by your scrollbars racing way passed your last row, or they are difficult to control, it is likely Excel thinks it has more data than it actually does and you need to reset it's UsedRange. All versions of Excel have an 'issue' with resetting the area it believes it is using on any sheet (UsedRange). This is brought about by say, entering data in columns to the right of the actual data or rows below it. To test where Excel believes it's furthest row or column...
    Filed under:

  • Open Excel how YOU want

    Start-up templates in Microsoft Excel...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.