Welcome to MSDN Blogs Sign in | Join | Help

June 2006 - Posts

Friday, June 30, 2006 8:13 AM

Defrosting your code

One of our team members recently noticed an issue with Excel VBA code running on Windows Vista (it is something that happens on WindowsXP too, it is just more pronounced on Windows Vista), so I thought I would write it up. While it is not the sort of
Posted by David Gainer | 16 Comments
Filed under:
Wednesday, June 28, 2006 7:20 AM

4 More Shortcut Keys

A while ago, I wrote a post about 214 keyboard shortcuts . In the last few months, we have added 4 more for one reason or another, so I wanted to pass them on. (I have not updated the matrix I included as part of that post, because I accidently misplaced
Posted by David Gainer | 18 Comments
Monday, June 26, 2006 8:06 AM

Excel And High-Performance Computing Part I

Fairly recently, the Microsoft Windows Compute Cluster Server 2003 team publically released their product. What is “Windows Compute Cluster Server”? Lots of information available here , but, to borrow a line from their site, Microsoft Windows Compute
Posted by David Gainer | 4 Comments
Friday, June 23, 2006 7:29 AM

Absent But Not Gone

Over the next week or so, I am taking some time off to head back home with my family. I have set up some content that, with any luck, will get auto published while I am gone, so there should be stuff to read. That said, I wont be around to reply to comments
Posted by David Gainer | 1 Comments
Thursday, June 22, 2006 8:13 AM

Calling all PivotTable users: Let us know how you like to summarize your data...

A few months back I wrote several posts about the improvements that we made to PivotTables in Excel 2007. I even showed how summarizing data in different ways is now just a right click away on the “Summarize Data By...” menu. What I didn’t show was that
Posted by David Gainer | 24 Comments
Filed under:
Wednesday, June 21, 2006 8:06 AM

Managed Add-In Improvements

Today we have the second of two guest posts from Patrick Smith, a program manager on the Office Programmability team. Overview and Background Managed code is becoming more and more prevalent in add-ins written for Microsoft Office products. Also shipping
Posted by David Gainer | 7 Comments
Filed under:
Tuesday, June 20, 2006 3:04 PM

The "Command Well"

One of the topics I was going to cover at some point was the "command well", which is the list of commands in the various Office products. You can use this list to add or remove things from the "Quick Access Toolbar". For example, for those of you that
Posted by David Gainer | 0 Comments
Monday, June 19, 2006 8:00 AM

2007 Microsoft Office System Primary Interop Assemblies

Today we have the first of two guest posts from Patrick Smith, a program manager on the Office Programmability team. Writing managed code against the 2007 Microsoft Office System products requires the use of an interop assembly. Just as we did with Microsoft
Posted by David Gainer | 5 Comments
Filed under:
Saturday, June 17, 2006 1:28 PM

Comments

Greetings – since I was in absentia for more than a week, comments are shut off for recent posts. Accordingly, I am going to reply here to the last round of comments here. For those of you that suggested new topics, I have written them down, and will
Posted by David Gainer | 15 Comments
Wednesday, June 07, 2006 11:50 PM

Suggestions Please

Over the next few days, I am on a ridiculously over-scheduled training course, so I will not be producing any new content until sometime mid next week (and probably not answering comments or emails until then too). In the meantime, I wanted to ask you
Posted by David Gainer | 23 Comments
Tuesday, June 06, 2006 9:58 PM

Fun And Games With Excel

Every release, part of what the team (and the entire company) does when working on a new release of Excel is use it in all sorts of ways (often referred to as “dogfooding”). We use it in our daily work, we build solutions that the team uses to manage
Posted by David Gainer | 9 Comments
Monday, June 05, 2006 10:13 PM

A Bit More On Charting

Last week, in response to my post on charting, Harlan pointed at a few Economist charts as examples of professional charts. Today, I spent a few minutes with Excel 2007 trying to create a similar chart. I thought I would share the results. The chart in
Posted by David Gainer | 19 Comments
Filed under:
Friday, June 02, 2006 3:13 PM

Some Words About Charting

Over the past few months, when I have posted information about charting in Office 2007, there has been plenty of feedback and discussion about the work presented. Today, I wanted to spend a bit of time addressing some of that feedback. When I read over
Posted by David Gainer | 15 Comments
Filed under:
Friday, June 02, 2006 3:04 PM

"Save As PDF" Not In The Box After All

A few months back, I wrote a post about how Excel 2007 will enable customers to save their work as a PDF file by simply using the Save As command from within Excel. Well, it turns out that’s not looking like it will be the case – the feature will be available
Posted by David Gainer | 5 Comments
 
Page view tracker