Office links for February-March
March 5, 2010 • JP • 1 Comment • Rate This Article
Time for another installation of the Office Cafe! Whew! I think I'll settle in and read this with a can of soda instead. I like the sugar rush better.
I may have shared this link before, but if you're using Office 2010, you'll want to read this article about bit compatibility:
Compatibility Between the 32-bit and 64-bit Versions of Office 2010
Summary: For customers working with large amounts of data, Microsoft Office 2010 is now available in a 64-bit version. This article discusses issues around the compatibility of the 32-bit version with the new 64-bit version and legacy 32-bit Office applications and their solutions. (12 Printed Pages)
(taken from White paper: Compatibility Between the 32-bit and 64-bit Versions of Office 2010)
I'm convinced that the only reason VBA was updated was to convert (to lock) the (new) 64-bit customers into using their proprietary code on new machines.
The Office 2010 section on MSDN has other articles you should read, including:
- Customizing the Office 2010 Backstage View for Developers
- Getting Started with VBA in Office 2010
- Introduction to the Office 2010 Backstage View for Developers
Spreadsheet Day was proposed on Debra Dalgleish's blog, but I don't believe a day was ever actually chosen. I think a poll is in order.
Ron de Bruin announced a new version of his RDBMail add-in for Excel and Outlook 2007/2010 on Dick's Blog. If you regularly email workbooks or sheets from Excel and need a quick solution, I would download it.
Oscar put a lot of effort into his dynamic stock chart and the end result looks great.
And the Microsoft Excel Team blog has the much touted post on Migrating Excel 4 Macros to VBA. Note that none of what you read in the article applies to Excel 2003 or 2007 — you'll need to upgrade to (or install) Excel 2010 in order to migrate your XLM macros to VBA. What I can't tell at the moment (and without a lot of web searching, any takers?) is whether they've duplicated all XLM functions.
For you Outlook fans, Microsoft announced the Outlook Social Connector (OSC) late last year and have followed up on their blog with Outlook Gets Social with LinkedIn, Facebook, and MySpace. This WILL work for Outlook 2003 and 2007. I don't understand why they're not just providing the interface and letting third party devs do it. They're putting more than a few existing Outlook social apps out of business. By the way here's the MSDN article if you want to read about developing an OSC provider: Developing an Outlook Social Connector Provider for Outlook 2010, Outlook 2007, and Outlook 2003
And finally, I saw a nice post by Visio Guy. It's nearly two years old, but has some nice VBA code in it. Visit Save Time & Simplify Your VBA Code With CallByName to find out how to use the CallByName function.
See you next time!
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
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 if you want to learn more about VBA. Keep Reading »
Previous Post: Add and return Excel.Worksheet references in VBA
Next Post: You know it's a bad (Excel) chart when …
Interesting site first time visit – linked by way of my great friend Debra Dalgleish site. Pleasure to view your infomation and views.