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

Blogs

  • Docs for Facebook

    Last week the beta of Docs for Facebook was announced at the f8 developer conference. Driven by Microsoft FUSE Labs , Docs is a great experiment on how the Office experience can come together in Facebook.  Takeshi Numoto recently posted some thoughts on this, to check it out head over to The Office Blog: http://blogs.office.com/b/office_blog/archive/2010/04/27/cloud-creates-new-opportunities-for-office-thoughts-on-docs-com-for-facebook.aspx Read More...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Thu, Apr 29 2010
  • Help and Training for Office 2010 and Office 2007

    With the launch of Office 2010, we are producing another wave of great help and training content. The new Office 2010 website ( office2010.microsoft.com ) delivers articles and demos that will quickly get you up to speed on the new features and functionality in Office. There are two key ways to get access to this great help and training content from right within Office 2010. When working on your document (or spreadsheet, etc.), you can click the icon in the upper right hand corner of the application...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Wed, Apr 28 2010
    Filed under: ,
  • Dynamic Columns in MS Query II

    Earlier, I posted about using ADO to query a select number of columns from a spreadsheet. It used the CopyFromRecordset method to get the data in the spreadsheet. In this example, I change the CommandText (SQL) property of an existing QueryTable to show the data. First, I used Data - Get External Data - [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 28 2010
    Filed under:
  • Dynamic Columns in MS Query

    Jeff commented that he wants to bring in the latest x columns in from spreadsheet using MS Query, where x is some number. The columns are expanding, so he doesn’t always know what the latest will be. I started with this example spreadsheet Note that the “date” headers aren’t really dates but strings (they have a [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 28 2010
    Filed under: ,
  • Prioritize List on a Worksheet

    In a previous Prioritize List on a Worksheet, I showed how to use a spin button to move values up or down. This code does the same thing, but moves the whole row rather than just one value. I tried to incorporate Eric’s comment, but it wasn’t any move efficient because I was [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Apr 27 2010
    Filed under:
  • VSTO: Automate MS Outlook in Excel using Template

    Introduction In Office Automation one of the cornestones, at least for me, is templates. Using templates in Excel, in Word and in Outlook creates value as they provide us with tools to customize documents and doing so gives us structural solutions that can be applied inside corporates. Personally I find it to be excellent whenever I can use templates as part [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Tue, Apr 27 2010
  • Windows Live Mail (WLM) and Excel problem part two

    Hi all If you set Windows Live Mail as your default mail program and try to mail from Office you get a general mail failure error two times, the third time it is working OK. The reason for this is that Windows Live Mail isn’t fully MAPI-qualified like Windows Mail or Microsoft Outlook. If you want to mail with from [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Apr 25 2010
    Filed under:
  • TM AutoChart: Connect chart axis parameters to cell values

    TM AutoChart is a shareware Excel add-in that links the minimum, maximum, major, and minor values of a chart axis to worksheet cells. http://www.tushar-mehta.com/excel/software/autochart/index.html Over the past few months I have been trying out different Ribbon layouts for chart related add-ins. For now, I have settled on a split button where the large button provides [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Apr 24 2010
    Filed under: , , ,
  • Conditional Formatting Rules Simplified

    Thanks to Amit Velingkar for writing this blog post. Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Thu, Apr 22 2010
  • Illegal File Names

    Function IsValidFileName(sFileName As String) As Boolean         Dim vaIllegal As Variant     Dim i As Long         vaIllegal = Array("/", "\", ":", "*", "?", "< ", ">", "|", """")     IsValidFileName = True         For i = LBound(vaIllegal) To UBound(vaIllegal)         If InStr(1, sFileName, vaIllegal(i))...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Apr 20 2010
    Filed under:
  • Top 10 Benefits of PowerPoint 2010

    On the heels of our recent announcement that Office 2010 has released to manufacturing , many of the individual Office team blogs have posted similar announcements and deep summaries about their specific aspects of Office. Over the next few weeks we’ll link to many of these posts to give you an overview of all the great features Office 2010 has to offer. Or, if you can’t wait, you can use the links to the right to go directly to the team blogs. First up is the PowerPoint team blog. They recently...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, Apr 20 2010
    Filed under:
  • Creating Dynamic Names in VBA

    I had an occasion to create about 25 dynamic named ranges. A tedious process, that. So I cooked up some code. All the ranges needed to start in row 2 and extend down as far as there is data. There wouldn’t be any blanks, so I didn’t worry about it. In this [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Apr 16 2010
    Filed under:
  • Listing Format Conditions

    I wrote some code to list out all the conditional formatting rules in a worksheet. It wasn’t as easy as I thought it would be. In Excel 2007, MS introduced some new format conditions like Icon Sets and Databars that complicate things. As a result, I didn’t get too fancy with the [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Apr 16 2010
    Filed under: ,
  • Display a message for a specific duration

    There are a number of instances where one may want to show a message for a specific duration. In other instances it might be for a specific duration or until the user acknowledges the message, whichever comes first. In the first category would be something like a splash screen or a very brief [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Apr 16 2010
    Filed under:
  • Office 2010 Reaches RTM!

    I am very excited to share some great news with you. Earlier today we reached the release-to-manufacturing (RTM) milestone for Office 2010, SharePoint 2010, Visio 2010 and Project 2010! RTM is the final engineering milestone of a product release and our engineering team has poured their heart and soul into reaching this milestone. It is also an appropriate time to re-emphasize our sincere gratitude to the more than 5,000 organizations and partners who have worked with us on rapid deployment and testing...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Wed, Apr 14 2010
« 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.