Daily Dose of Excel

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

Hi all

Today I talked about the search results from the Excel 2007 help (Offline) with a fellow MVP. Our results where different, my results were correct and useful but his results on the same search topic were useless. The reason why we have different search results is because that I have installed the help update from 4/28/2009 that contains the latest revisions and additions to content in the Help files.

Note: Search “Offline” give the best search results.

How do you change it to Offline if it is set to “Connected to Office Online” ?

Press F1
If you see “Connected to Office Online” in the bottom right corner then click on this
and choose “Show content only from this computer“

I suggest that you install this update to get better search results when you search offline.
You can get the updates through Microsoft Office update or download and install them by using the link below.
Maybe you have it already installed ?

Updates for Microsoft Office Excel 2007 Help
http://www.microsoft.com/downloads/details.aspx?FamilyID=2fbf47a2-e338-4ed8-92f2-b0a146e8593c&displaylang=en

Note: there are also updates for the other Office programs, see the links on the bottom of the page.

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

Hi all

Today I upload a new page with examples to Hide or display Custom Tabs, Groups or Controls with VBA code

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

If you have suggestions to make the examples better please let me know.
I am no expert but love to try new stuff like this.

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

Hi all

I upload a new page today with code to create Zip files with the free Zip program 7-zip.
This program is also very useful if you want to open Office 2007 files as a archive
without changing the extension to .zip so you can see/edit the files in the archive.

Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA)
http://www.rondebruin.nl/7zipwithexcel.htm

I will add a Unzip page to my site for 7-zip it next week

For examples for WinZip or the default Windows Zip program see the Zip (compress) section here
http://www.rondebruin.nl/tips.htm

Have fun and let me know if you have suggestions or find a bug

Hi all

Read the information about the changes in Office 2007 SP2 on this page:

http://blogs.technet.com/office_sustained_engineering/default.aspx

Regards Ron de Bruin