Archive for the ‘Excel12’ Category.

New Excel for Old Guys

Ribbon X book

As I mentioned in a recent post, I’ve finally installed Excel 2007 (Office Ultimate, actually) on my home computer. I had it on a virtual machine back when it was in beta, but now it lives as a first-class citizen on my hard drive right next to Office 2000, Office XP, and Office 2003.

I’m still using Office 2003 at work, so I’ll be relearning the UI every morning. When I was working with 2007 pretty intensively, it took about two weeks for me to be proficient with the ribbon. From my standpoint as a user, I actually preferred the ribbon because it offered keyboard shortcuts for all its commands. As I commented in one of Simon’s latest rants discussions, applying a style or border via the keyboard was not easy in previous versions.

I don’t mean to imply that style and border access is some sort of panacea of Excel UI evolution. It’s just something in the plus column. In the minus column, there’s the two weeks it took me to figure out where everything is. Two weeks isn’t a lot of time, but the question remains whether the ribbon provides enough benefit to overcome that cost. Also, I was a motivated user. I wasn’t being dragged begrudgingly into 2007, I was a willing participant.

Another minus, I’ve heard, is programmability. I have not attempted to program the ribbon, but at a minimum there will be a learning curve. Whether it proves worth it remains to be seen. I’ve recently purchased RibbonX: Customizing the Office 2007 Ribbon, so I should be on my way.

Screen real estate seems to be a hot ribbon topic. During the beta, I kept my ribbon minimized and it would magically appear when I began using the keyboard shortcuts. Mouse-centric people would probably prefer to have the button in plain view. I can’t speak for them, but for me the ribbon took up less space. I do agree that the button size is ridiculous. I’ll bet you dollars to donuts I haven’t clicked a paste button in at least five years. Even my grandma knows Control+V. But someone must have been clicking those paste buttons and sending that data to Microsoft.

I don’t use tear-off menus very often, being the keyboard guy that I am. But I do see the value in them for others. It was a big miss not having them in 2007. I predict that if nothing else changes on the ribbon, it will have tear-offs at some point.

Finally, a word from the field. A fellow accountant and friend emailed me today about Excel 2007. I repeat his email in its entirety:

This new Excel is driving me crazy. Trying to find where everything is a pain in the A$$

I asked if I could quote him on that, and he responded, in part:

Back in November, I took a laptop home that had new Excel and I was trying to finalize a worksheet for Budget meetings the next day. I was trying to do a save as so I could save the file under a new name, and I swear it took 10 minutes before I accidentally hit that windows button and saw the save as command. I was about ready to chuck the laptop out my bedroom window.

The difference between this guy and me? I was trying to learn Excel 2007 and he was trying to actually do something with it. Fortunately, I have the luxury to ease into it. Others won’t be so lucky and they have my sincere sympathy.

Dealing with Ribbons and Menus - Avoiding Two Versions

Hi all

When you open your Excel 97-2003 file in Excel 2007, one that creates its own menus,
the first thing you notice is that you don’t see your menus. Where’d they go? Then you discover
them - shunted over on the Add-ins tab. Not exactly the ideal user interface.
How are your users going to find them there?

What you want is an application that runs as a first class citizen in Excel 2007, one that takes full advantage
of the ribbon, and yet runs as it always did in Excel 2003. Yet you do not want to maintain two versions of
your app. Two versions are always a nightmare, so difficult to keep in sync.

So, is this possible? Is it possible to have one version that’s at home in Excel 2007 and Excel 2003? Yes it is;
there are two approaches from me and Jim Rech of this problem on this new page on my website.

http://www.rondebruin.nl/compatiblemenu.htm

If you have suggestions or other feedback let me know.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Macros are disabled when you open password protected workbooks

Hi all

If you have the problem above in Excel 2007 read this page
http://www.rondebruin.nl/password2007.htm

It seems that not all machines have this problem.
I have two Vista machines that will run the code without adding the DWORD.
Very strange and I really like to know why.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Page update: Copy a range from closed workbooks (ADO)

Hi all

I update my ADO page today.
http://www.rondebruin.nl/ado.htm

The code is also working in Excel 2007 now (Excel 2000-2007).
I use Late binding now to avoid private mails like “It is not working”
When you use the Subfolder option in Example 7 it will loop through all files in all levels below the rootfolder.

If you have problems or suggestions let me know.

I wish all readers of this blog a Merry Christmas and a Super 2008.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Office 2007 SP1

Via the US ISV Developer Team Blog

Microsoft Office 2007 SP1 will be available for download Dec 11. The improvements in 2007 Office System SP1 are in response to direct feedback from power users at large organizations or indirect feedback from home and Office users through the Dr. Watson bug-reporting system.

I haven’t seen any details about what’s been done, but don’t expect any UI changes or charting improvements. They might have fixed some stuff, buy I’m not getting my hopes up.

Describe your Office 2007 use:
It is my primary office productivity suite
I use it occasionally or when it’s required
I’ve used it very sparingly out of curiosity
I haven’t upgraded yet, but I plan to
I haven’t upgraded yet, and I will resist as long as possible

  
Free polls from Pollhost.com

Copy a customized QAT from one workbook to another (Add-in)

Hi all

I create a small Excel add-in to copy a customized QAT from one workbook to another.
http://www.rondebruin.nl/imageqat.htm#QAT

QAT Add-In

Because it not use very common code I like to hear from you if you have problems
or if there are there better ways to do it ?

I hope a few of you can test it for me.
You can find a button on the Add-Ins tab to open the userform

Thanks