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

Hi all

This week I create a new page about Galleries on my site.
http://www.rondebruin.nl/galleries.htm

I not say it is good but it is a good start.
It was the first time I really work with Galleries so if you have suggestions please let me know.

Thanks

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

Hi all

I update two pages for Excel 2007 on my website.

Create and mail PDF files with Excel 2007
http://www.rondebruin.nl/pdf.htm

VBA code examples for Tables in Excel 2007 or a List in Excel 2003
http://www.rondebruin.nl/tablecode.htm

Maybe useful for the readers of the blog
If you have Suggestions or find bugs let me know

Thanks

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

Hi all

A common question in the newsgroups is this:
How do I send an e-mail with VBA code from another account then the default account?

In Office 2007 we can use SendUsingAccount now to change the account in Outlook.
I create a small example page yesterday with a example.
http://www.rondebruin.nl/mail/account.htm

Let me know if it is working for you.

Thanks

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

Hi all

This week I create a small Add-in to add a few options to the contextual Table Tools tab.
This is a start and love to have feedback what you miss or like to see in a add-in like this.

This are now the options in the Add-in

1) Turn AutoFilter On or Off
2) Clear Filter of the ActiveCell’s column
3) Special Filter options : Filter on selected Cell value, Color, Font color or Icon
4) Special Sort Options : Put selected Cell Color, Font Color or Icon on top and Custom Sort
5) Copy Visible data to a new worksheet
6) Copy visible data to a new workbook
7) Delete visible data
8)) Print Table
9) Split data of every unique value in a column to a new worksheet of the same workbook
10) Split data of every unique value in a column to a new worksheet in a new workbook
11) Split data of every unique value in a column to a new workbook in a new folder
This option creates a worksheets with hyperlinks to the workbooks so you can open them easy.

You can find the add-in together with a test workbook on the page
http://www.rondebruin.nl/table.htm

Thanks for looking at it
See also the links in the “More Information” part

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