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
