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

Blogs

Sort By: Most Recent | Most Viewed | Most Commented

  • Setting a Base Directory

    If you want your Excel app to default to a specific directory when opening or saving files, see Changing the Current Directory. Be sure to read the comments. I have a slightly different situation. I want my app to open to a specific directory that will give me easy access to sub directories. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Sep 2 2010
    Filed under:

  • Count Active Customers

    Jake wants to know, given an active date and an inactive date, how to count the customers that were active in a certain time period. The ones we want are highlighted in yellow. The formula is =COUNT(D2:D21)-SUMPRODUCT(($C$2:$C$21>=D25)+($D$2:$D$21< =C25)) It’s easier to figure out who is not active during that date range and subtract it from the total. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Sep 1 2010
    Filed under:

  • =VLOOKUP (uhh…now what?)

    Today’s post is brought to you by Anneliese Wirth, a writer on Office.com. On Office.com , the term “VLOOKUP” frequently bubbles up in our list of high-volume search queries. My job is to figure out why this is and what specific information people are actually looking for when they type “VLOOKUP” into the search box in Help or on our web site. The “VLOOKUP” query appears to represent a bunch of different questions. Certainly, one of the main ones has to do...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Tue, Aug 31 2010
    Filed under: , ,

  • Dymo LabelWriter Part II

    A couple of weeks ago, I posted some code to print labels on a Dymo LabelWriter 450. I wanted to post the finished code because it has a few more tricks in it. Function PrintBoardFileLabel(ws As Worksheet) As Boolean     Dim bReturn As Boolean     Dim vaPrinters As Variant     Dim i As Long     [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Aug 31 2010
    Filed under: , ,

  • Abbreviating Company Names

    Last week I was creating file folder labels with my new Dymo LaserWriter 450. The information on the folder label is serial number, part number, company name, and purchase order. Normally, this works great. However, I ran into one on Friday with a 30 character part name and a 29 character company [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Aug 30 2010
    Filed under:

  • Using SQL Server Compact Edition Database with Excel

    Introduction Often we see questions about acquiring data from various data sources like SQL Server Databases, MDBs, Excel and text/xml-files in webbased Q&A forums and in blogs. But what I see very rarely is any discussions on how to retrieve data from Microsoft SQL Server Compact Edition (SSCE) databases and to populate Excel worksheets with [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Sun, Aug 29 2010
    Filed under: ,

  • Bushy Trees

    A favorite peeve of mine is code with “bushy trees.” I first saw this phrase in Kernighan and Plauger’s Elements of Programming Style. Recently, I saw some code that checked if a RefEdit control referred to a single cell that contained a non negative integer. I cleaned up the formatting some since the original [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Aug 28 2010
    Filed under: ,

  • You Asked: What the heck is Scroll Lock

      This week’s post is written by Amy Miller. Amy is a writer for Office.com. She’s written and edited content for Excel, Access, OneNote, and InfoPath.   Imagine you’re working in a spreadsheet and you innocently press the arrow keys on your keyboard to move to another cell, but instead of moving to another cell, the entire spreadsheet moves. You may have asked yourself, what the heck just happened, and how do I make it stop? Lucky you. You’ve encountered that pesky little problem called...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Aug 25 2010
    Filed under: ,

  • A Hundred Thousand Name Managers!

    Hi folks, Many of the regulars here probably know the Name Manager utility, which Charles Williams and I created and give away for free on our websites. Rumour has it this is one of best tools ever built for the Excel developer. I won’t argue with that! Anyway, as I was looking at my web stats today I [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Aug 19 2010
    Filed under: , , ,

  • Excel Web App leads to healthier snacks for kids

      Today’s blog post is brought to you by Roxanne Kenison. Roxanne is a writer on Office.com who writes primarily about Office Web Apps and Office Starter.     My son starts Kindergarten this fall. I’m excited, but a little sad that our days of co-op preschool are over. Our local community college sponsors a co-op preschool program where parents run the preschool. Each parent works one day per week in the classroom, rotating through a series of jobs. We use an Excel spreadsheet to keep...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Aug 18 2010

  • Showing Hidden Sheet and Workbooks Dialog in VBA

    A tip from Scott: Windows - Unhide, from the menu, shows the Unhide dialog box for unhiding workbooks. In vba, Application.Dialogs(xlDialogUnhide).Show gets the job done. Where it gets tricky is unhiding worksheets. Via the menu, Format - Sheets - Unhide In vba, the name of the dialog is not so intuitive. Application.Dialogs(xlDialogWorkbookUnhide).Show Poorly named, for sure, but you’ve been warned. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Aug 12 2010
    Filed under:

  • Got lots of text in a cell? Make it readable

      Today’s blog post is brought to you by Gary Willoughby. Gary is a writer on Office.com who has created and edited content about Excel, Access, and Project.     Sometimes, I find I have text in a cell that spans far past its own column or…yikes, maybe even off the screen. Because I tend to be a little borderline compulsive, that bothers me just a bit. Of course, if I autosize the cell by clicking the column border on its right edge, all the cells below that cell could end up being...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Aug 11 2010
    Filed under: ,

  • Printing to a DYMO LabelWriter 450 from VBA

    I recently had to make some file folders at work. About five minutes after I was done, I purchased a DYMO LabelWriter 450. I was using one of those label makers where you punch in the text, hit print, and press down on a lever to cut the label. Then you have [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Aug 10 2010
    Filed under: ,

  • Working with Folders

    Introduction It’s quite often that we need to work with folders in various Excel solutions. It involves creating, deleting, moving, copying and update folders with or without any user interactions. In this article I will discuss and show the code in order to work with folders. In the first part I will cover the basic [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Mon, Aug 9 2010

  • Microsoft Office 2010 File Compatibility

    Have you been looking for a tool to help you assess compatibility of your existing Office files and macros as you prepare to deploy Microsoft Office 2010?  We have recently released the tool to help you identify potential concerns before you migrate. The Office Migration Planning Manger 2010, referred to as OMPM, has been released to help you assess and migrate documents for Office 2010.  Download OMPM 2010 from the Microsoft download center, and yes it’s free. The OMPM tool has been created...
1 2 3 4 5 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.