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

January 2010 - Daily Dose of Excel

  • Perfect Training

    Have you even attended a really good training session? What about it made it good? I’d like to develop some training sessions. I get a lot out of preparing and presenting (and I hope the attendees get something too). Rather than developing training that looks like every other session I’ve attended, I thought it [...] Read More...
  • MZ Tools Non-Modal Dialogs

    I’ve recently rebuilt my computer, which means I get to figure out all those little settings that I’m accustomed to. Since re-installing MZ Tools, the accelerator keys don’t work on any of the dialog boxes. Take the Add Procedure dialog, for instance With this open, I click Alt+A and instead of actuating the Add [...] Read More...
  • Declaring API functions in 64 bit Office

    Hi everyone, The release date of Office 2010 is closing in and with this new version we’ll have a new programming challenge. Office 2010 comes in a 32 bit and a 64 bit version. Especially API function declarations need to be adjusted for the 64 bit environment. We’ll have to change a declaration like this one:     Private [...] Read More...
  • VBA Page of Pages in a Cell

    In Page of Pages in a Cell, Jan Karel uses defined names and Excel 4 Macro commands to return the current page and total pages in a workbook. The problem is that it doesn’t work properly when the cell is repeated (e.g. File - Page Setup - Sheet - Rows to Repeat at Top). [...] Read More...
  • Cash Advances on Credit Cards

    I had the unfortunate opportunity to learn how cash advances on credit cards work. The particular card I saw was from Capital One, but I think they all work the same. There are three important things to know about cash advances: The interest rate is huge - usually in the mid-20% neighborhood Interest starts on [...] Read More...
  • Margins Don’t Fit Page Size

    I got the error message “Margins Don’t Fit Page Size” when I tried to Print Preview after setting the scaling to Fit to 1 pages wide by 1 tall. At 100% scaling, the spreadsheet took six pages to print. But at 1×1, it took 12,438 pages to print. Here’s Page Break View: I [...] Read More...
  • Culling You RSS Feeds

    Last month, Debra lamented: It’s a tedious process to go through the list individually, especially since the Show Details doesn’t stay open. I started working on a solution, but quickly grew tired of it. Then today, The Grumpy Old Programmer posted some ruby code to find the date certain blogs were last updated. It renewed [...] Read More...
  • Friday Link Dump

    Cloud Excel Excel Web App 2010 Overview Editing in Excel Web App – Part I I haven’t used the web app yet, so take my comments in that light. Fidelity appears to be the word of the hour. Clearly MS thinks it’s important, but I’m not so sure. I don’t expect my bank’s website [...] Read More...
  • Problems related to KB973475 and KB973593

    Hi All, Many users (including customers of mine) have experienced trouble with two recent security updates by Microsoft, see: http://support.microsoft.com/kb/973475 and http://support.microsoft.com/kb/973593 There seem to be two hotfixes to this problem: KB973475 Excel 2003 hotfix package : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us KB973593 Excel 2007 hotfix package : http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522 If you experience problems with...
  • Capitalizing Web Addresses

    In written correspondence, which is best: dailydoseofexcel.com DailyDoseofExcel.com DailyDoseOfExcel.com www.dailydoseofexcel.com www.DailyDoseofExcel.com www.DailyDoseOfExcel.com http://dailydoseofexcel.com http://DailyDoseofExcel.com http://DailyDoseOfExcel.com http://www.dailydoseofexcel.com http://www.DailyDoseofExcel.com http://www.DailyDoseOfExcel.com I personally prefer #1, all lowercase and no unnecessary prefix. But I think I’m in the minority. One of the capitalized ones is probably...
  • Opening Files on Startup

    Let’s say that you want to open a specific file when you start Excel. Here are some options: XLSTART If you have Excel installed, you have a folder called XLSTART. Mine’s here C:\Documents and Settings\Dick\Application Data\Microsoft\Excel\XLSTART. On my Windows 7 machine running Office 2010 Beta, it’s here C:\Program Files\Microsoft Office\Office14\XLSTART\. (Are we putting [...] Read More...
  • 2009 in Review

    Top 10 Page Views in 2009 Post Page Views Creating CSV Files 33,947 Sumif Between Two Dates 19,336 Number Stored as Text 15,003 Writing to a Range Using VBA 12,165 Automating Internet Explorer 11,248 Progress Bar 11,212 Testing for Empty Cells 10,581 Pattern Matching 9,665 Calculated Fields in Pivot Tables 9,321 Maxif Minif Functions 8,162 Most Viewed 2009 Posts Post Page Views Vlookup on Two Columns 6773 Vlookup 2695 Get the Path to My Documents in VBA 2258 Excel Sample Data 2230 Reading Xml Files...
  • New Year’s Resolution: No More Offset

    On Simon’s blog, sam comments regarding OFFSET vs. INDEX: There is a huge performance hit. … You will notice hardly any difference in the Calculation times But the recalculation times will significantly different in case of OFFSET- to the tune of 25-30 times slower compared Index. I’ve heard this many times before, but I guess I’m just lazy. I’ve [...] Read More...
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.