Browse by Tags

Using LINQ to find and open in Excel 2007 the newest file in a folder

This is one of two approaches inspired by Dick Kuslekia’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 [...] Read More...

Published Wed, May 05 2009 2:50 AM by Daily Dose of Excel

Filed under: General, Add-ins, User Interface, Fluent UI, .Net

Change built-in groups in the Ribbon

Hi all It is not possible to add to or remove controls from built-in groups in the Ribbon. For example, the Format Painter button from the Home tab’s Clipboard group cannot be removed from this group. But there is a way around this restriction. We can hide a built-in group and then duplicate it with RibbonX. And then we can [...] Read More...

Published Thu, Aug 08 2008 3:51 PM by Daily Dose of Excel

Filed under: General, Excel12, User Interface

To Disable or Not To Disable, That Is the Question

Joel Spolsky says don’t: Instead, leave the menu item enabled. If there’s some reason you can’t complete the action, the menu item can display a message telling the user why. I thought it was pretty common knowledge that users don’t read message boxes. Anyway, I’m squarely in the disable-menu-items-that-aren’t-applicable camp, and I never hide items. Take the [...] Read More...

Published Wed, Jul 07 2008 12:01 AM by Daily Dose of Excel

Filed under: User Interface

Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

Hi all, For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like: Description Before After Cell Errors 100 10 Corrupt Names 1000 0 Unused styles 232 0 So I figured I’d put a [...] Read More...

Published Wed, May 05 2008 1:39 PM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, User Interface, Userforms and Controls

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 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 [...]

Published Thu, Nov 11 2007 4:36 PM by Daily Dose of Excel

Filed under: General, Excel12, Downloads, User Interface

Customize the images of the buttons in the QAT

Hi all I add a new page to my site with examples to change a button image of a button in the QAT for all workbooks or for one workbook. Making a QAT Add-in of the one workbook example seems a good way on this moment if you want to change the buttons images of your QAT. http://www.rondebruin.nl/imageqat.htm Suggestions or comments [...]

Published Tue, Nov 11 2007 1:15 PM by Daily Dose of Excel

Filed under: General, Excel12, User Interface

Syndication

Recent Posts

Tags

News

Archives