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

December 2010 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Crossword Builder Version 2

    I couldn’t get my crossword template to work just right, so I’m taking a new tack. I used this Yahoo! crossword to test, so I don’t want you to think I filled this in on my own. I tried that once and it’s really hard. I went with textboxes overlaying cells to keep the [...] Read More...
    Filed under:

  • Crossword Template

    Do you like to spend your free time writing and editing crossword puzzles? Who doesn’t. Well, hopefully this crossword template will make it easier. It starts with this blank puzzle. You enter a space to indicate a black cell and the opposite cell also becomes black. When you’re done entering spaces, you get a perfectly symmetrical [...] Read More...
    Filed under: , ,

  • Disconnected Recordsets in VBA Classes

    I read VBA Has No Class over at Excel Do, Dynamic Does with interest. Bob says: As you can see, the disconnected recordset can do everything a collection class can do, but without having to hand-roll any of the methods, recordset has them builtin. I’m not ready to give up collection classes yet. But I [...] Read More...
    Filed under: ,

  • Outlook Plain Text Tables

    I’ve never been quite satisfied with my attempts to paste tables into plain text Outlook emails, so I decided to do it by brute force. Sub CopyRangeToPlainTextOutlook()         Dim rCell As Range     Dim rCol As Range     Dim aMax() As Long     Dim lCol As Long     Dim sOutput As String     Dim [...] Read More...
    Filed under:

  • Odd Shape Selection Behavior

    In Excel 2003, open a new workbook and add this code. Sub TestShapes()         Dim i As Long     Dim sType As String     Dim shp As Shape     Dim s1 As String, s2 As String         For Each shp In Sheet1.Shapes         shp.Delete     Next shp         [...] Read More...
    Filed under:

  • Determining Whether An Excel Workbook Contains PowerPivot Data

    By David Hager One of the issues with the 1st version of PowerPivot for Excel is that the add-in does not expose a programmatic interface with Excel. Thus, the data in the PowerPivot window cannot be manipulated through VBA or VSTO. This creates a problem in that there is no straightforward way to identify whether an [...] 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.