Hi all

Maybe a useful file if you want to change the Excel 2010 Ribbon?

I add a file to my site with all Excel control idMso’s of Excel 2010 RTM
I add a Advancedfilter to the MS file so it will filter on groups and display a picture of the group.

http://www.rondebruin.nl/files/RDB_Built-in_idMso’s_Excel_2010.zip

You can also find the download link on this page
http://www.rondebruin.nl/ribbon.htm

I notice one bug in 2010, maybe you want to test it also ?

For 2010 I have add this line to the Advancedfilter macro(Get_Ribbon_Info) because it delete
the format of the banded rows in a part of the Table when you select the “All (No Filter)”
option again after you make another selection in the dropdown.

.Range(“B12?).Value = .Range(“B12?).Value

The file is working OK in 2007 with and without this line
But in 2010 you need it. This file is working OK now in 2007 and 2010.

Thanks

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

Hi all

If you set Windows Live Mail as your default mail program and try to mail from Office
you get a general mail failure error two times, the third time it is working OK.

The reason for this is that Windows Live Mail isn’t fully
MAPI-qualified like Windows Mail or Microsoft Outlook.

If you want to mail with from Excel with Windows Live Mail as your default
mail program you will get the problem above when you use the default mail
buttons in Excel or try to mail with VBA SendMail.

I Update my Mail add-in for Outlook Express and Windows Mail so it also work with Windows Live Mail.
The first add-in on the page is only for Microsoft Outlook and the second one for OE, WM and WLM.
http://www.rondebruin.nl/mail/add-in.htm

Also the SendMail code examples on my code page are working now in WLM.
http://www.rondebruin.nl/sendmail.htm

I also add a new sheet template for OE, WM and WLM
http://www.rondebruin.nl/mail/divsheettemplate.htm

Let me know if you have problems, I test it on a few machines but you never know.

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

Hi all

Because Windows Mail is removed from Windows 7 you must install a third party mail program
or use the free Windows Live Mail (also with newsgroups).
I see that a lot of people start using WLM now but Office has a problem with this program.
Note: you have the same problem if you use WLM in Vista
If you set WLM as your default mail program and try to mail from Office you get a general mail failure error
two times, the third time it is working. The reason for this is that Windows Live Mail isn’t fully
MAPI-qualified like Windows Mail or Outlook.
You have the same problem when you want to mail with SendMail in VBA so I want to change all my SendMail
code examples on my site with this workaround but hope you can test it for me before I do that.

Using a loop seems the best way as a workaround.

On Error Resume Next
For I = 1 To 3
.SendMail “”, _
“This is the Subject line”
If Err.Number = 0 Then
Exit For
End If
Next I
On Error GoTo 0

Set WLM as your default mail program first before you test the workbook that you can download here:
http://www.rondebruin.nl/files/WLMtestworkbook.zip

When you push the button in the workbook it creates a mail with the active sheet
Note: it will not send the mail it this example but show it.

I like to know this :
Is it working the first time when you push the button?
Is there a better way?

Thanks for testing

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

Hi all

FYI

I upload a new add-in named RDBMail for Excel/Outlook 2007-2010 this week
http://www.rondebruin.nl/mail/add-in.htm

The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options
and a option to insert a worksheet template to your workbook so you can send more then one
mail with one click because the info for each mail is saved in the worksheet.

You have the option to send as workbook or PDF for every mail option.

If you have problems let me know

Regards Ron de Bruin

Hi all

I create a 2010 section on my Tip index page with the first pages about 2010.
http://www.rondebruin.nl/tips.htm

Load different RibbonX when opening file in Excel 2007 or 2010
Download to find the names of the Excel 2010 ControlIDs (819 kb)
Backstage view in Excel 2010

I not say they are good but this are my first examples that I want to share.
If you have useful content or have links to articles about 2010 please post them.

And a PDF article on MSDN is published :

Creating and Sending PDF Files from Excel 2007 and Excel 2010
http://msdn.microsoft.com/en-us/library/ee834871(office.11).aspx

Merry xmas and happy new year
Regards Ron de Bruin

Hi all

Together with Kirill Lapin and Hector Miguel Orozco Diaz I start with a webpage with International Excel problems. If you have suggestions/comments about the content that is on this page now or have problems with workbooks in different language versions let me know. We try to make this a collection of International Excel issues so feedback and problems/solutions are welcome.

International Excel Issues
http://www.rondebruin.nl/international.htm

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

Hi all

If you add a button to the QAT only for your workbook to run for example a macro it is possible that the button is gone when you reopen the workbook. Seems to be a SP2 bug.
If you have this problem also in SP1 please let me know.

I have add some info to reproduce the bug and a fix to this page
http://www.rondebruin.nl/qatbuttonbug.htm

I hope it is useful

Regards Ron de Bruin

Hi all

I have create a new worksheet template for Excel/Outlook 2007-2010 for mailing this week.
(with great suggestions from Dave Peterson)

You can download it here
http://www.rondebruin.nl/mail/outlooksheettemplate.htm

I think on this moment it have a lot of mail options that are very easy to change/use.
You can mail one or many custom mails with one click of a button.

But I love to hear what you miss in this template or not like in it.

Read the information on the webpage and in each data validation tip that you can find in each cell
and let me know if you have suggestions.

Thank you very much

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