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

March 2011 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • loss of state of the global IRibbonUI Ribbon object

    Hi all There is a common problem when you are working with the Ribbon with RibbonX and VBA. The ribbon object (which is initialized when Excel loads your file) can loose its reference to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations. There is simply no easy built-in way to recover [...] Read More...
    Filed under:

  • Introducing TM Retro Slicer beta 1

    Those who have used an Excel 2010 slicer may have wanted to see that capability in earlier versions of Excel. I like what Microsoft did with slicers in 2010 and wanted to extend that capability backwards. For those who haven’t used a slicer, it is a filter on a particular pivot field shown [...] Read More...
    Filed under:

  • Introducing TM Tornado

    Tornado diagrams graphically display the result of single-factor sensitivity analysis. This lets one evaluate the risk associated with the uncertainty in each of the variables that affect the outcome. Single-factor analysis means that we measure the effect on the outcome of each factor, one at a time, while holding the others at their [...] Read More...

  • Add userform controls on the fly

    For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1051 Add userform items on the fly.shtml Tushar Mehta Read More...

  • Credit Card Processors

    Charles asks about credit card processors for accepting payments from clients. Like me, he uses Paypal, but would like to explore some other options. If you’re a freelancer or otherwise accept credit cards, who do you use? I’m not sure what the criteria should be, but here’s my list Reasonable transaction fees Easy to [...] Read More...
    Filed under:

  • Introducing TM Chart Leader Lines

    TM Chart Leader Lines simplifies the management of leader lines in a chart. This add-in, which works only with Excel 2007 or later versions of Excel, allows the easy interactive arrangement of data labels and their associated leader lines. What should not come as a surprise to anyone who has worked closely with charts and [...] Read More...

  • Inside the Box

    Not Excel related, but some interesting reading on hardware, memory, and the boot process. Motherboard Chipsets Memory Map How Computers Boot UP You could spend all day reading articles on that site. If you’re into that kind of thing. Read More...
    Filed under:

  • Pitch Template

    From Wikipedia Pitch is an American trick-taking card game derived from the English game of All Fours (Seven Up). … The modern game involving a bidding phase and setting back a party’s score if the bid is not reached. The only “real” pitch is four-point, keep low, bid or set to win. For my tournament, we [...] Read More...
    Filed under:

  • Waiting on Websites

    On this post, Jan Karel Pieterse commented that I should put a timer in my wait code and I couldn’t agree more. It seemed like a good opportunity to just get that code out of the main procedure. Here’s what I came up with. Sub Gotosite()         Dim ieApp As InternetExplorer     [...] Read More...
    Filed under:

  • Get Data from Website that Requires a Login

    If you want to get data into Excel from a website that requires a login, you may have already been frustrated that web queries don’t work so well. By automating Internet Explorer and the login process, you can get to that data. This example shows how to login, retrieve a table, and paste [...] Read More...
    Filed under:

  • Change Case… ala’ Microsoft Word

    Last week, more absent-minded than usual, I forgot the software I was in. I looked for the Change Case … format dialog in Excel. It’s not there, of course. It’s in Word. It’s in PowerPoint. It’s not in Excel. So I took a morning and wrote one. Word gives you [...] Read More...
    Filed under:

  • Mapping US Cities

    Another J-Walk YouTube playlist. These songs have US Cities in the title (except for two). I created a map of these cities using Excel and BatchGeo.com. First, I went to the playlist and copied all of the songs. Then I pasted it into Excel Each picture is a hyperlink, so I ran some code to extract [...] Read More...
    Filed under:

  • VBA Confessions

    I’m guilty and I’d like to come clean. I’m probably guilty of a lot of things, but I only wish to confess two transgressions. I’ve been working with some code lately, some mine, some not, and it made me appreciate proper coding techniques. I’m generally a believer in the one-exit-point rule. But I [...] Read More...
    Filed under:

  • Spreadsheet Morality

    After six years in my previous job, my department ran like a well-oiled machine. Not just well-oiled, super-cooled frictionless nano diamonds. I had top-shelf, A-1 people working with me, so I don’t want to discount that. But I also used technology, including a large dose of Office automation, to make the processes [...] Read More...
    Filed under:
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.