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

Daily Dose of Excel

Sort By: Most Recent | Most Viewed | Most Commented

  • Excel Links

    First, from the double trademark infringement department, there’s Excel®RainMain®, who says: Whether it’s your homework, day job, or just a new idea, let the Excel Rain Man make your life easier! Submit a Request, inquiries are free! (see How it Works for further details) Pay for homework service? For a fee, I’ll read your lit homework [...] Read More...
    Filed under:

  • To Disable or Not To Disable, That Is the Question

    Joel Spolsky says don’t: Instead, leave the menu item enabled. If there’s some reason you can’t complete the action, the menu item can display a message telling the user why. I thought it was pretty common knowledge that users don’t read message boxes. Anyway, I’m squarely in the disable-menu-items-that-aren’t-applicable camp, and I never hide items. Take the [...] Read More...
    Filed under:

  • Identify Empty Cells in VBA

    Whenever I need to determine if a cell is blank, I call the IsEmpty function on the Value property. If IsEmpty(ActiveCell.Value) Then This anonymous blogger uses vbNullString. If ActiveCell.Value = vbNullString In other news: In Firefox, Cntl+Click on a hyperlink and it will open that link in a new tab. Except for the aforementioned blog's heading. [...] Read More...
    Filed under:

  • Create a QueryTable from an Excel Source in VBA

    Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...
    Filed under: ,

  • Using an Analysis Template — Updating the data source

    The motivation for this quick and incomplete draft was Dick Kusleika’s post on distributing/communicating a PivotTable template (http://www.dailydoseofexcel.com/archives/2008/05/21/pivottable-markup-language/). In the approach I’ve adopted for the past few years, the basic idea is to separate the data from the analysis and presentation. Then, a simple piece of code lets one update the data connections in [...] Read More...
    Filed under:
  • Read More...

  • Excel Blog Happenings

    The Contextures Blog has moved off of the wordpress.com domain and onto the contextures.com domain. Check it out if you haven’t, update your feeds if you have. PTS Blog is holding a contest for physics and engineering spreadsheet models. Since I’ve mentioned it on my blog, I get to submit six entries. I’m [...] Read More...
    Filed under:

  • On-the-fly data entry form

    Hi all, So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again. I intend to get a bit of discussion on this one, so bear with me. I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of multiple data tables, each [...] Read More...

  • Alive and Well

    Howdy. It’s been quiet at the ol’ DDoE lately, but I thought I would check in and let you know I’m still around. I generally slow down a little in the Summer, but this Summer has been surprisingly busy. I have some nice Excel posts in the queue. In the mean [...] Read More...
    Filed under:

  • Settling Debts

    You owe me $325.00 as of 1-June. Instead of paying me, you note that I will owe you $778.00 on 12-July and that we should just settle up then. I, being an accountant, suggest instead that we settle up on 10-Aug. Here’s one way to find that date: Start by setting up a [...] Read More...

  • Variable Hyperlinks

    Excel provides an easy way to create a table of hyperlinks and even save the workbook as a web page. The built-in method for creating a hyperlink is Insert > Hyperlink (Ctrl+K). The problem with this method is mass changes, like renaming your server. Editing each one (if you have a lot) [...] Read More...

  • Fixing Links To UDF’s in Addins

    Hi All, Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called “User Defined Functions” (UDF). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s work as expected. You get into trouble [...] Read More...

  • Giving IE the Focus

    Ginger comments: The only thing I can’t do is to get XL to open the existing IE window so I can ’sendkeys’ to do that part. I can only see similar posts for “create.object” related to IE, and nothing for “get.object” (or whatever will work). According to XtremeVBTalk, GetObject doesn't work with IE and you have to [...] Read More...
    Filed under:

  • PivotTable Markup Language

    How do you communicate a pivot table to someone? I have a huge table of payroll transactions and I created a pivot table for my worker's compensation premium audit. Someone else who has Quickbooks could use this pivot table for their own purposes, but I don't know how to tell them how to [...] Read More...
    Filed under:

  • Recording Macros

    There’s an interesting discussion at Smurf about the macro recorder. I rarely use it, but I used to use it quite often. I actually just used it last week for something to do with FormatConditions, but I don’t remember the details. Intellisense or the Object Browser usually gets me where I want [...] Read More...
    Filed under:
1 2 3 4 5 Next > ... Last »
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.