Office Links for June


It was a busy month! Here's the link roundup.

UK Excel Developer Conference

Excel DevCon 2010 was announced, and there has been a lot of blogging about it. Simon Murphy, Ross McLean and Charles Williams (of Decision Models) will be presenting.

Ross links to the venue and the agenda. He also included a nice photo showing England's goalie making a save.

Simon provides booking details. If you are going, book now to take advantage of the discount (150 GBP vs 200 GBP in July).

Visit Excel Developer Conference for more information and booking details.

Soccer Mania

The Excel Team Blog has extended their World Cup / Excel 2010 Soccer Challenge. If you have an Excel workbook for tracking World Cup scores, make it stand out by adding realtime scores updated from the web by visiting Realtime World Cup Scores.

Sentence Case

In Convert to Sentence Case, Chandoo provides a formula for converting to sentence case (that is, first word capitalizes, the rest lower case). I've also written an article about case changing in Excel, which includes some VBA functions for doing the same.

My concern is that some proper nouns will be skipped, but coding the logic would be very difficult, even with VBA. I'm sure there's a way to leverage the Wordnik API here to check for proper noun capitalization.

MSDN Links

Microsoft went crazy this month, adding a lot of content to their Office Developer section. Here are just a few of the links:

Visit Windows API Declarations and Constants for a list of Windows API declarations. Includes 64-bit declarations for Office 2010!

For assistance creating charts in Word 2010 using VBA, see Creating Charts with VBA in Word 2010. The code used in the article may be downloaded here.

What's new for developers in Outlook 2010 lists new members for various objects in the Outlook object model.

If you develop solutions for Office 2010 and want to see some icons you can use, visit Office 2010 Add-In: Icons Gallery. You'll need Word 2010 or a compatible viewer.

A few more MSDN articles you might be interested in:

Microsoft has also introduced the VBA Developer Center, which may be accessed from Office VBA Developer Center or the aptly-named (via John Durant's blog).

If you want to see MSDN updates in your RSS reader, instead of waiting for me to post them, add the Microsoft Office Developer Center RSS Feed to your reader.

For a free 184-page E-book about Office 2010, visit First Look: Microsoft Office 2010.

New Pages

I've been steadily documenting the Outlook Object Model with encapsulated functions and sample VBA code.

Sample Wordnik App

I've posted a sample Word add-in that utilizes the Wordnik API on the Wordnik API code samples page. The application is called Wordnik For Word and it uses several of the methods available on that page. I'm planning on updating that page shortly with new developments from Wordnik.

Bad Behaviour

Have you been blocked by the Bad Behaviour plugin? If so, let me know.

The plugin analyzes user agent behavior (among other things) to block malicious access attempts. Invariably, it may block legitimate access attempts, but displays a Turing test to allow you to quickly get past the block.

Code Requests

I've asked before, but I'll ask again: is there some piece of code you'd like to see here?

If so, leave a comment and I'll do my best to get it done. I do have a list of posts I'm working on, but I don't know what you want to see unless you tell me.

If you'd like to contribute, visit the Contribute page and submit your post for consideration.

And by the way, while you're here, take the visitor survey. Your responses will help make this a better site.

See you next time.

About JP

I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »

Related Articles:

Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

comment bubble 9 Comment(s) on Office Links for June:

  1. Nice collection of links, just wish I had time to read them!

    But I did read "Excel 2010 Performance: Optimizing Performance Obstructions" and found this statement:

    "Starting in Excel 2007, opening and saving performance is only slightly slower than the XLS format."

    which seems odd coming from Microsoft, because I have found that some files save much quicker as an xlsb than they do as an xls. The files that were particularly slow as an xls had a lot of VBA code, linking to an API for a non-Microsoft program, so that may have had something to do with it.

    Has anyone else found a similar speed-up with xlsb file saving?

    • What do you mean by "linking"? Early bound reference?

      ps- I've also noticed that file size is a lot smaller with xlsx over xls.

  2. To use the API you have to call an initiation function at run time, so that's late binding, right?
    There are also a couple of VBA modules with a few hundred lines of "Declare Function" statements, calling functions in the main API dll file..

    Saving as an xls takes 10 seconds or more (much the same in 2007 or earlier versions), but comes down to a second or so as an xlsb file.

    I haven't noticed much difference with other files, but I'll pay more attention when I'm saving files with a lot of code.

    • It depends on how the objects are declared. If they are declared "As Object", it's always late bound.

  3. There are no references to objects. All data transfer is done through functions, mostly with double arrays.

    I have just checked the save time for a largish file with a lot of pure VBA code. The xlsb version (about 1.5 MB) saved in less than 1 second, and the xls (about 4 MB) took about 5 seconds. That was with 2010, but I think 2007 was similar.

  4. chrisham writes:

    I am not sure if this has been covered in other excel forum, but it would be neat to have a code or an excel-addin that would assist in creating a Dynamic Name rather than using the formula method of Offset and CountA

  5. chrisham writes:

    JP, here's a suggestion for an add-in that you could create and market hopefully…… But I have always wanted to have formula auditor that displays the formula progression in a bigger window. Not sure why MS is content with such a small dialog box that does not expand.
    Its a pain when you have to work out some mega array formula.
    Just an area that you may want to explore……..

This article is closed to any future comments.
Peltier Tech Charting Utilities for Excel