Daily Dose of Excel

Hi all

FYI

A few weeks back I start working on my first Mac, and I must say I love the OS but there is a lot of work to do in Office for the Mac.
My idea is to go through all my webpages and see if I can make the VBA code also working in Excel 2011.

I start this problem page
http://www.rondebruin.nl/mac.htm

I also add VBA code examples last week to mail from Excel 2011 with Apple Mail and Outlook 2011.
If you have problems with Excel on a Mac post it here, maybe I can check it out and find a workeround for it.

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

Hi all

FYI, I add this page last weekend to my site :

Enable or Disable custom Ribbon buttons in Excel 2007-2010
http://www.rondebruin.nl/enable.htm

I also have a page for hiding and displaying :

Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm

If you have suggestions or good or bad comments let me know(I am no expert)

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

Hi all

There is a common problem when you are working with the Ribbon with RibbonX and VBA.
The ribbon object (which is initialized when Excel loads your file) can loose its reference
to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations.
There is simply no easy built-in way to recover the handle to the Ribbon when there are problems
in or with your code. The only way to fix it is to close reopen your workbook, not a very user friendly way.

But MVP Rory Archibald came up with a great idea in a post in the MrExcel forum.
I created a example workbook based on Rory’s idea on the following page :

loss of state of the global IRibbonUI Ribbon object
http://www.rondebruin.nl/ribbonstate.htm

If you have suggestion or comments let me know so I can add it to the page

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

FYI

Excel MVP Dennis Wallentin allow me to publish his Lotus Notes examples on my site.
Great to have them online again so I can point Lotus Notes users to them when they mail me.

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

Have a nice day

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

Hi all

I update my GetImage page for Excel 2007-2010.
Thanks to Rob Bovey LoadPictureGDI (from Stephen Bullen) is also working now in Excel 2010 64 bit.

You can find the code in the example workbooks on the page below
http://www.rondebruin.nl/getimage.htm

FYI : Because of a bug in Word 2010 the code is not working in Word 2010 for ribbon controls.
If I have more info about this bug that I can share I will post it here.

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

Hi all

I created this page this week :
http://www.rondebruin.nl/contextmenu.htm

I am curious about what developers think about the option in Excel 2010 to change contextmenus with RibbonX. Creating a dynamic menu in the Cell menu in Excel 2010 for example is easy to do because every time you right click on a cell it will run the getContent callback so it is very easy to change the menu.

Check out the three examples workbooks that you can download on that page for Excel 2010.

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

Hi all

I want to let you know that I upload a new version of Jim Rech’s button image add-in today.
You can find it in the “Find the names of the button images” section on my Ribbon page.
This great Add-in is working now in Excel 2007 and in Excel 2010.

While you there check out also my new file to find the control, group and Tab names in Excel 2010.

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

Have a nice day

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