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

Blogs

  • C# Macro Recorder

    Well, not quite. via Unhandled Perception, it's the Code Converter. Convert VB to C# or C# to VB From Sub ConvertCode()         Dim i As Long     Dim x As Double         For i = 1 To 100         x = x + (i ^ 2)     Next i   [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 6 2009
    Filed under:
  • Euler Problem 45

    Euler Problem 45 asks: 'Triangle, pentagonal, and hexagonal numbers are generated 'by the following formulae: 'Triangle       T(n)=n(n+1)/2       1, 3, 6, 10, 15, ... 'Pentagonal     P(n)=n(3n-1)/2      1, 5, 12, 22, 35, ... 'Hexagonal      H(n)=n(2n-1)        1, 6, 15, 28, 45, ... ' 'It can be verified that T(285) = P(165) = [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Feb 8 2009
    Filed under:
  • VSTO Office FAQ Entry List

    The VSTO support team has released the first FAQ for VSTO and Office. It is a start and it single out the most frequent questions together with the answers: VSTO Office FAQ Entry List This is good for all developers new to VSTO. What are annoying, at least to me, is that all the answers points to solution [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Sun, Feb 8 2009
    Filed under:
  • Simple Expense Tracking With New Excel 2007 Functions

    Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, gives an overview of some new functions in Excel 2007 and along the way shows us how to do some simple expense tracking. Considering the current economic environment, one may desire to better keep track of personal expenses. The new functions introduced in Office Excel 2007 simplify this effort. Here is how: given a list of expenses sorted by dates and categories (food, travel, clothing, etc.), how do I find how much...
    Posted to The Excel Team Blog by Microsoft Excel on Mon, Feb 9 2009
  • Which Range Am I Counting?

    Steven asks a good question, which stems from James Cane’s comment Ever wondered why the Count property returns the number of columns of a range which was obtained from the Columns property? After all, in a regular range, Count returns the number of cells. The answer is that each Range object contains an internal flag which specifies [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 9 2009
    Filed under:
  • Paying the Check

    In Splitting the Check, I describe how I determine receivables and payables after a trip where one person spends money on behalf of others. Once the totals are computed, determining who pays whom is a manual process. It doesn't take long to optimize the transfers in your head for a small number of [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 10 2009
    Filed under:
  • Excel Memory Usage

    Earlier today I was experiencing a problem with Excel 2003. I was getting this error message: “Code execution has been interrupted”, as described at this Mr. Excel thread. I restarted my computer and all seemed to be fine. Then I got another error message about OnKey in a project I wasn’t even [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 11 2009
    Filed under:
  • Ego Charts

    Jorge Camoes discussed skyscraper bar charts. He writes: Listen, unless you work for a statistics office, you should never create a chart like this. I know, it’s irresistible to check how well my state ranks, but identifying each and every data point in a virtually limitless bar chart makes no sense in most cases. Does anyone [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Feb 12 2009
    Filed under:
  • Site News

    JP suggested I add an option to allow commenters to subscribe via email. I took his suggestion and installed Subscribe to Comments 2.1, so we’ll give that a go. Don’t forget that you can read all the comments quickly (and ignore the ones you don’t like just as quickly) by subscribing to the [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 13 2009
    Filed under:
  • Excel Movie Reviews

    I recently watched The Contract. It was terrible. It was worse than The House Bunny (my wife picked that one, I swear). You’re probably saying, “I like John Cusack. I like Morgan Freeman.” Yes, they’re good. Everyone else in the movie is terrible. How does a really bad movie become [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 13 2009
    Filed under:
  • SharePoint - The Start

    Last year I decided to learn more about Microsoft Office SharePoint Server (MOSS) and in particular Excel Services. Instead of setting up a VMWare configuration I decided to buy a physical server to which my developing machine will be connected to as the only client. Because of my security approach none of these two machines have access to Internet. Yes, I’m [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Sat, Feb 14 2009
  • Euler Problem 79

    Euler Problem 79 asks: 'A common security method used for online banking is to ask the user 'for three random characters from a passcode. For example, if the 'passcode was 531278, they may asked for the 2nd, 3rd, and 5th 'characters; the expected reply would be: 317. ' 'The text file, keylog.txt, contains fifty successful login attempts. ' 'Given that the three characters [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Feb 15 2009
    Filed under:
  • External Links

    Ron sez: What happens often is that one person will have one of these spreadsheets open and the other spreadsheets linked to the subject spreadsheet closed and decide to insert a column that throws off the references of the closed linked spreadsheets. If the person knew which spreadsheets were linked to it, the person could open [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 16 2009
    Filed under: ,
  • My own Euler problem

    Hi everyone, With all these Euler posts I thought, why not post my own? Suppose the following: I have a products table set up like this: Code ProdName Price 0001 Product1 556.68 0002 Product2 977.41 0003 Product3 350.62 0004 Product4 509.16 0005 Product5 748.4 0006 Product6 802.96 (list goes on to as much as 5000 products) And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...] Read More...
  • Translating Excel Applications

    I've never translated anything I've done in Excel to any other language. As I was designing a userform the other day, I began to think about translating. How could I build this userform so that it could be translated easily? I thought about putting all of the my user interface strings in [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 17 2009
    Filed under:
« First ... < Previous 3 4 5 6 7 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.