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

May 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Euler Problem 206

    Euler Problem 206 asks: Find the unique positive integer whose square has the form 1_2_3_4_5_6_7_8_9_0, where each “_” is a single digit. First thing to note is that Euler wants the integer, not the square that conforms to the pattern. That failure to RTFQ costs me a couple of hours as I kept trying to check in [...] Read More...
    Filed under:

  • Hungarian Notation Again

    JP has a nice post called ‘I promise’. I agree with his last two points. I will, however, still be explicitly setting my object variables to Nothing. He’s right that it’s unnecessary code, but I don’t think that makes it worthless. If setting objects to Nothing should be excluded, then so [...] Read More...
    Filed under:

  • New Excel Blog

    Nate Oliver: Mr. Excel MVP, Microsoft MVP, Renaissance Man. And now…blogger. He just started and there’s already good content. Go check it out. Nate Oliver’s Blog Read More...
    Filed under:

  • Advanced Excel Conference

      Excel MVPs Bob Umlas and Jon Peltier are hosting two days of programming and charting, Wednesday and Thursday, June 17-18, on the boardwalk in Atlantic City, NJ. This is our fourth conference in Atlantic City, and the three so far have been very popular. Visit the Advanced Excel Conference page for information and registration. Read More...
    Filed under:

  • Include All in Array Formulas

    Let’s say you have some data like, oh I don’t know, First Name, Last Name, Gender, State, and some number. You could add up the numbers for all the males in Texas with an array formula. =SUM((C2:C101="Male")*(D2:D101="Tx")*(E2:E101)) If you didn’t know that, go read Anatomy of an Array Formula. One of my workshop attendees had [...] Read More...
    Filed under:

  • Dallas Wrap Up

    Well, I’m back from Dallas. I spent a couple of days on my golf game (and napping game) and a couple of days presenting at the Excel and Access Integration Workshop. The workshop went well. On Monday morning, Mike Alexander talked about integrating Access and Excel from the Access point of view. [...] Read More...
    Filed under:

  • Adding RibbonX code to an Office OpenXML file using VBA

    My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers… In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...] Read More...

  • Ravine Enivar

    J-Walk posted about the word 'ravine'. If you spell it backwards, each letter is offset 13 characters from its forward-spelled cousin. He says: Who can come up with another? You may use Excel. I came up with these using the list of words at orchy.com: although I'm not sure how some of those are words. [...] Read More...
    Filed under:

  • Excel Dashboard and Visualization Boot Camp

     The second Excel Dashboard and Visualization Boot Camp takes place Wednesday through Friday of next week, May 20-22, 2009, in Frisco, Texas. There are a few spots remaining, and it’s not too late to sign up. Excel MVPs Mike Alexander and Jon Peltier are teaming up for a repeat of last October’s successful boot camp. Join [...] Read More...
    Filed under:

  • Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA)

    Hi all I upload a new page today with code to create Zip files with the free Zip program 7-zip. This program is also very useful if you want to open Office 2007 files as a archive without changing the extension to .zip so you can see/edit the files in the archive. Zip Activeworkbook, Folder, File or Files with [...] Read More...
    Filed under:

  • Euler Problem 100

    Euler Problem 100 asks: If a box contains twenty-one coloured discs, composed of fifteen blue discs and six red discs, and two discs were taken at random, it can be seen that the probability of taking two blue discs, P(BB) = (15/21)×(14/20) = 1/2. The next such arrangement, for which there is exactly 50% chance of taking [...] Read More...
    Filed under:

  • Hidden Columns in HTML

    When I save my Excel workbook as a webpage, my hidden columns are no longer hidden when viewed in Firefox. It seems to be OK in IE6. I unhid the columns, turned the font white, made the columns thin, and it seems fine. I know some of you are against white-font-on-white-fill hiding, but I think [...] Read More...
    Filed under:

  • Excel and Access Integration Workshop

    A little shameful self promotion: Mike Alexander and I are putting on an Excel and Access Integration Workshop in Dallas in a couple of weeks. Here’s the details. Excel and Access Integration Workshop Monday, May 18, 2009 - Tuesday, May 19, 2009 Homewood Suites 3240 Parkwood Boulevard Frisco, Tx 75034 Map and Directions Microsoft MVPs Dick Kusleika (Daily Dose of [...] Read More...
    Filed under:

  • Editing elements in an Excel OpenXML file using VBA

    Hi Everyone! Today I finally found time to actually post a brand new article on my website. Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article. Enjoy!! Regards, Jan Karel Pieterse www.jkp-ads.com Read More...

  • Using LINQ to find and open in Excel 2007 the newest file in a folder

    This is one of two approaches inspired by Dick Kuslekia’s post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/). I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and [...] Read More...
1 2 Next >
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.