Daily posts of Excel tips…and other stuff
Archive for the ‘Fluent UI’ Category.
Many of my spreadsheets use Excel 2003 Commandbars for application control.
Having loaded these spreadsheets into Excel 2007, I see my commandbars presented on the Add-In tab of the Ribbon.
I’m a late starter with Excel 2007 ribbons, but I guess it’s time to move.
I’ve found that the various guides on the Internet tend to throw you [...]
This is one of two approaches inspired by Dick Kusleika’s post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/).
I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and [...]
Ribbon, you’re nothing to me now. You’re not a brother, you’re not a friend. I don’t want to know you or what you do. I don’t want to see you at the hotels, I don’t want you near my house. When you see our mother, I want to know a day in advance, so I [...]
Without further ado:
<customui xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab idMso="TabHome">
<group idMso="GroupClipboard" visible="false" />
</tab>
</tabs>
</ribbon>
</customui>
I’m finally working my way through this book:
OK, so here’s my initial impressions. Initial, mind [...]
