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

Blogs

  • 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
  • Office 2010, our approach to delivering the best productivity experience across PCs, phones and browsers

    As we gear up to launch the next version of Office, I want to share a bit of what's in store.  Each new version of Microsoft Office is developed through a fundamental approach that includes extensive research, planning, and most importantly, lots of listening to our customers to discover what they really need from their software to be more productive. The goal of this approach (what some might call stoic ☺) is to deliver a product that reflects how essential our products are in the professional...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Wed, Apr 14 2010
  • On a Personal Note

    So, do you want to know what’s been happening lately? Too bad, I’m telling you anyway. I’ve been using a Dell Latitude D810 for nigh on five years now. I really like this laptop with one exception. The power is good, the keyboard is great, the touchpad is awesome. The VBA port [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 14 2010
    Filed under:
  • Windows Live Mail (WLM) and Excel problem

    Hi all Because Windows Mail is removed from Windows 7 you must install a third party mail program or use the free Windows Live Mail (also with newsgroups). I see that a lot of people start using WLM now but Office has a problem with this program. Note: you have the same problem if you use WLM in Vista If [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 14 2010
    Filed under:
  • Creating Address Labels from a Spreadsheet Programmatically

    Today's author is MVP Bill Jelen of MrExcel.com . The following code example takes a list of addresses arranged as one address per row, and copies them onto another sheet, arranging them to fit on printable address labels. The workbook must contain two sheets, one named "Addresses" and one named "Labels". The addresses on the Addresses sheet must be arranged as one address per row, with the Name in Column A, Address Line 1 in Column B, Address Line 2 in Column C, and the City...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Apr 14 2010
  • Hear In Your Language in Office 2010

    Hello, my name is Kate Kelly; I am a Program Manager in the Office Global Experience Platform (GXP). In Office 2010, GXP focused on features designed for customers working in multiple languages, such as updating Language Preferences and adding translation tools to Word, Outlook, PowerPoint and OneNote. In Office 2010, one of our new features is an on-the-fly translation feature called Mini Translator . The Mini Translator allows you to translate single words or many paragraphs simply by hovering...
  • Add a Table of Contents to your Workbook Programmatically

    Today's author is MVP Bill Jelen of MrExcel.com . The following code example verifies that a sheet named "TOC" already exists. If it exists, the example updates the table of contents. Otherwise, the example creates a new TOC sheet at the beginning of the workbook. The name of each worksheet, along with the corresponding printed page numbers, is listed in the table of contents. To retrieve the page numbers the example opens the Print Preview dialog box. You must close the dialog box...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Apr 7 2010
  • Modern Excel Charts

    Debra sez: If you want to make your Excel charts look like they were made in 2010, instead of 1982, see the Excel Charting tutorials on Jon Peltier’s blog. However, if you feel like kicking it old skool… Problems: I couldn’t read the title and y-axis, so I took a stab. I don’t know how to turn the y-axis text [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 7 2010
    Filed under:
  • Microsoft Office Mobile 2010 Beta Expiration on April 5th

    Last year we released Microsoft Office Mobile 2010 Beta , a suite of productivity applications for Windows Mobile 6.5 phones, on the Windows Marketplace for Mobile . First and foremost, we want to thank everyone who has tried Office Mobile 2010 Beta and has given us valuable feedback. The Beta expired on April 5, 2010. We apologize for the inconvenience this may have caused. While the expiration date was mentioned in the product terms of use, we realize that you may have questions and we decided...
    Filed under: ,
  • ByRef Arguments and the Application.Run Method

    The Application.Run method is a versatile mechanism to call a subroutine particularly in another workbook or add-in. Its one documented limitation, if we want to call it that, is that all arguments are passed by value (ByVal). So, how does one pass an argument by reference (ByRef)? For a version in a page by [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Apr 5 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.