Daily posts of Excel tips…and other stuff
Archive for the ‘Excel12’ Category.
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 [...]
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
My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers…
In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...]
Hi Everyone!
Today I finally found time to actually post a brand new article on my website.
Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article.
Enjoy!!
Regards,
Jan Karel Pieterse
www.jkp-ads.com
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
Ever wondered what it means to have Excel multi-thread its calculations? On a 64bit I7 computer, crunching 500,000 rows of calculations for the Euler 36 problem resulted in the below. The display was from the 64bit version of the Process Explorer program (www.sysinternals.com though now a part of Microsoft at http://technet.microsoft.com/en-us/sysinternals/default.aspx).
HTML clipboard
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,
I’ve just published a new article on my website. Here is the introduction:
“This article explains how you can use styles to ease maintenance of your spreadsheet models.
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done [...]
