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

November 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Getting Started in VBA

    My off-the-cuff recruit a new VBA programmer week comment got a modest amount of traction around the ‘tubes. Yet, I didn’t want to wait a whole year to provide these links. From msdn’s Getting Started with VBA… series. Are you facing a repetitive clean up of fifty tables in Word 2010? Do you want [...] Read More...
    Filed under:

  • Methods in Excel Podcast

    Go check out the first Methods in Excel Podcast hosted by Ross McLean. The first guest is Simon Murphy of Codematic. I’m slotted for a future show, so I’m looking forward to that. Read More...
    Filed under:

  • Changing names of some files in a directory

    This started off by helping myself to Dick’s code in ‘Removing Spaces from File Names’ (http://www.dailydoseofexcel.com/archives/2009/11/12/removing-spaces-from-file-names/) but quickly evolved to meet my own needs. First, was the requirement to replace a certain text string by another. I added 3 parameters to the subroutine (Dirname, ReplaceWhat, and ReplaceBy). Also evident was that some files had [...] Read More...
    Filed under: ,

  • Office Web Apps

    I’m trying to be the last blog on earth to announce the Office 2010 Beta. Included in 2010 are Office Web Apps. With Microsoft Office Web Apps, you can access documents from virtually anywhere. Whether you’re editing a document from home or collaborating with someone around the world, Office Web Apps help you work the [...] Read More...
    Filed under:

  • Learn VBA to be Lean

    Lean Office with Excel and VBA We have noted that many people are not as adept at using the software we have placed at their finger tips as we would like to think. As a result, we have found that one of the significant losses in the front office is time wasted that could easily [...] Read More...
    Filed under:

  • Visualizing data in Excel: How would you interpret this graphic?

    Because I have no clue. It’s from an university alumni magazine. The names I’ve smudged (or tried to anyways) are the various colleges. Could this graphic be done in Excel? Yes. Should it? Read More...
    Filed under:

  • CodeColorer

    On JP’s recommendation I’m trying CodeColorer for syntax highlighting. Public Sub LoadFromFile()         Dim xmlDoc As MSXML2.DOMDocument     Dim xmlNodes As MSXML2.IXMLDOMNodeList     Dim xmlNode As MSXML2.IXMLDOMNode     Dim i As Long     Dim clsRandom As CRandom         Set xmlDoc = New MSXML2.DOMDocument     xmlDoc.Load Environ("USERPROFILE") & "\My Documents...
    Filed under:

  • Visualizing data in Excel: Balancing the physical and logical dimensions of a chart

    When Excel creates a chart it assigns, by default, certain physical dimensions to the chart. These physical dimensions (height and width) are independent of the logical content of the chart. So, in the case of a column chart the physical shape of the chart is the same irrespective of whether it contains 2 [...] Read More...
    Filed under: , ,

  • Removing Spaces from File Names

    I inherited a folder with a bunch of files in it. Almost every file had spaces in the name. I abhor spaces in file names. Also, I need to put these files in Subversion, so the names would have all be encoded so they'd work as URLs. That is, all of [...] Read More...
    Filed under:

  • Programming Music

    When I’m working in Excel, Access and/or VBA, I’m usually listening to my iPod. That means mostly rock from the ’60s and ’70s and a few other songs thrown in for good measure. There’s a good amount of blues, some country that doesn’t suck, and Amy Winehouse (bit of an outlier, that). When I’m [...] Read More...
    Filed under:

  • JoinRange

    Here's a UDF that's been done about a million times before. So why write my own? Oh, I don't know. It's faster to write it than to find one on the internet and modify it I suppose. Public Function JoinRange(rInput As Range, _     Optional sDelim As String = "", _     Optional [...] Read More...
    Filed under:

  • Euler Problem 188

    Euler Problem 188 asks: The hyperexponentiation or tetration of a number a by a positive integer b, denoted by a^^b or ba, is recursively defined by: a^^1 = a, a^^(k+1) = a(a^^k). Thus we have e.g. 3^^2 = 33 = 27, hence 3^^3 = 327 = 7625597484987 and 3^^4 is roughly 103.6383346400240996*10^12. Find the last 8 digits of 1777^^1855. Euler uses [...] Read More...
    Filed under:

  • Four Letter Words

    Andy commented: There's one other similar conundrum that has always intrigued me: What 3-letter suffix can be added to the most letters of the alphabet to make valid 4-letter words? True word nerds just use their brains and knowledge of language. Guys like me use VBA. Warning: This code takes forever to run. Run it at your [...] Read More...
    Filed under:

  • Target a screen resolution

    I run on a wide screen 22" monitor (1680 x 1050). More than once I've delivered a prototype to the customer, and they've needed to scroll to find all the buttons, because their monitor was smaller than mine. Here is a procedure for resizing the Excel Application to a specified dimension (measured in pixels). Now I can [...] Read More...

  • Three Letter Words

    I was thinking about passwords recently. How I got from thinking about passwords to this post is a long and boring story, so I'll spare you the mental chain. The end of that chain was this thought: I can take the letters F and R and put a vowel in between them [...] Read More...
    Filed under:
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.