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

Blogs

  • Getting Array Data from a Filtered List in VBA

    Getting data from an Excel sheet into an array is usually best accomplished with a statement that looks something like this: vMyArray = Sheet1.UsedRange.Value I thought it would be keen to fill an array from a filtered list, so I coded Sub ArrFilteredList()         Dim vArr As Variant         vArr = Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Value       [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Mar 8 2010
    Filed under:
  • Information about ExcelKB

    Since 2004 I have been running ExcelKB where I have posted articles about Excel and .NET/VSTO on a regular basis. Overall it has had a quite a number of visitors and also a great number of page views. Under all these years I have paid for the service of using a Microsoft SQL Server database to handle all [...] Read More...
  • Plain and Pretty

    Mike Alexander tells me that I have to sell, so sell I shall. First, the pretty: Microsoft MVPs Jon Peltier (Peltier Technical Services) and Mike Alexander (DataPig Technologies) are joining together again to bring you our acclaimed Excel Dashboard and Visualization Bootcamp! This 3-day boot camp is designed for Excel users who need to more effectively synthesize [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Mar 5 2010
    Filed under:
  • Get Office for Today or Tomorrow

    Today’s post is just a quick status update to keep everyone in the loop on the progress Office 2010 is making, as well as to provide finalized details for our Office 2010 Technology Guarantee. Starting today, consumers who purchase and activate Office 2007 will be able to download Office 2010 at no additional cost when it becomes available in June 2010. All you need to be eligible for this program – Office 2010 Technology Guarantee – is the following: Purchase Office 2007, or a new PC with Office...
  • Office Automation

    Someone asked if anyone automates Office applications any more. That struck me as kind of funny. If I had to guess, I would guess that there are more lines of VBA code (poorly written or not) that automate Office applications than all the COBOL, VB6, PHP, and any other language you can think [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Mar 4 2010
    Filed under:
  • PowerPivot Alpha Geek Challenge

    There was a recent contest with PowerPivot, see the details of the contest here: http://wildfireapp.com/website/6/contests/19877?order=recency&view_entries=1   There were some great PowerPivot reports submitted, including some from our MVPs: Bill Jelen created a “Tag Cloud & SmartArt Updated Via PowerPivot!” report:   Tushar Mehta created a “Visualize US population trends over the last 150 years” report: Check out all of the entries here: http://wildfireapp.com/website/6/contests...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Mar 3 2010
    Filed under: ,
  • PowerPivot - Part 3 of 4: Conditional Shape Colors

    Part 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/ Part 2: http://www.dailydoseofexcel.com/archives/2010/02/27/powerpivot-part-2-of-4-prepping-the-census-data/ As mentioned in the Part 1, I had developed this technique to conditionally color shapes some time ago. Based on customer feedback and my own experience I made changes to simplify the various connections required to make it all work. Also, documenting the technique was easier to do with a webpage [...] Read...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Mar 2 2010
    Filed under:
  • Look Up Information From Your Phone

    A few weeks back we went through an overview of mobility scenarios in the post Mobility in Office 2010 . Today’s post describes how to search and look up information on SharePoint web sites with your mobile phones. There are various investments in SharePoint 2010 focused on enabling mobile experiences, including using Smartphones and feature phones to access documents, lists, calendars on SharePoint 2010, performing people and document searches, and receiving SMS alerts on SharePoint content. These...
    Filed under: ,
  • Web Query Lessons

    I’ve recently learned some things about Web Queries that I’d like to share with you. But first a little background. You create a Web Query in Excel 2007 by clicking From Web on the Data tab. This launches a browser within Excel through which you navigate to a web page and select a [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Mar 2 2010
    Filed under:
  • Populate TreeView Control with Tables, Views and Columns from a SQL Server Database

    Introduction This is the second blog post about populating a TreeView control. In the first blog post, Populate TreeView Control with Tables and Columns from MS Access Database, I used a MS Access database to populate a TreeView with its tables and related columns. In this blog post I will instead be using a SQL Server Database. The first example is [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Tue, Mar 2 2010
    Filed under:
  • IsHex Function

    I have a need to verify some user input is hexadecimal (0-9 and A-F). Public Function IsHex(sInput As String) As Boolean         Dim lResult As Long         On Error Resume Next         lResult = CLng("&H" & sInput)             IsHex = sInput = "0" Or lResult > [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Mar 1 2010
  • PowerPivot - Part 2 of 4: Prepping the census data

    Part 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/ Since Excel 2007 (and later) can handle a million rows of data, I figured it made sense to explore PowerPivot (PP) with a data set larger than that. In addition, I have had a long time curiosity about the US census data. So, this seemed an appropriate time to combine the [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Feb 27 2010
    Filed under:
  • PowerPivot - Part 1 of 4

    After the MVP Summit I was motivated to further explore a Microsoft add-in for Excel 2010 called PowerPivot. I don’t know all its capabilities but at the very least it can analyze millions of rows of data. If you are using Excel 2010 you can download the add-in from http://www.microsoft.com/downloads/details.aspx?FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca&displaylang=en Do keep one thing [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 26 2010
    Filed under:
  • Interim Solution: COM Shim Wizard for Excel 2010 64-bit

    For some days ago Misha Sheerson published an article about using the present version of the COM Shim Wizard for the coming Excel 2010 64-bit. This is an iterim solution and we should expect a new updated version of the COM Shim Wizard when Excel 2010 has been launched. I must admit that I have been [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Fri, Feb 26 2010
  • Listing Formulas

    This code will list all the formulas in the selection in the Immediate Window. Sub ListFormulas()         Dim rCell As Range         If TypeName(Selection) = "Range" Then         For Each rCell In Selection.Cells             Debug.Print String(4, " ") & rCell.Address(0, 0), rCell.Formula         Next [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 26 2010
    Filed under:
« First ... < Previous 63 64 65 66 67 Next > ... Last »
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.