Sitemap  · Français  · English  · Deutsch

• Home
• Contact
• Imprint

• Blog
  • Recent posts
  • Categories
  • » General
  • » Office 2010
  • » VSTO
  • » Experiments
  • Archive
• Products
• Trainings
• Tutorials
• Customers
• Downloads
• Links

Home » Blog » Recent posts

Recent posts

Please note, that these articles are mostly a translation of our German articles. As English is not our native language, the translations may have some mistakes. Please feel free to contact us, if you find incomprehensible statements.

Mostafa Ashour Ashour is a program manager for Microsoft Maren, a new transliteration tool that allows users to communicate in traditional Arabic while typing on a Roman alphabet keyboard. This Tool can be download on the egyptian section of the Microsoft Site. This link is provided at the end of this article. As I have relatively large number of visitors to my site from arab countries (especially my article NETWORKDAYS.INTL() and WORKDAY.INTL() in Excel 2010), I though it may be a good idea to write about this tool. After downlading the tool, we can run the setup application.

Please note that some of the following screenshots were made on my German system,
I hope it would be clear what is meaned.


Continue…

In Excel 2007, it is possible to link a chart or an axis title to a cell by using a formula. However this was not possible when using VBA. The correponding objects have now been extended in Excel 2010, as you can see in the sample file which can be downloaded at the end of this article. The following image shows a screenshot of this sample file.


Continue…

We are happy to announce that we have released on 03/01/2010 the next version 1.50 Build 010310 of our freeware Excel Soccer World Cup 2010 Planner. The Excel file can be downloaded on its website www.en.excel-soccer-2010.de. The new versions includes now a chart for the prediction game and a sheet for userr defined settings. The image below shows a screenshot for the charts sheet.


Continue…

Today, I had a closer look on the changes to the “AddIn” object and the new object “AddIns2” in Excel 2010. The “AddIn” object has been only extended by the property “IsOpen”, allowing to check programmatically if a specific Add-In is loaded or not. The new object “AddIns2” lists, unlike the already existing object “AddIns”, all available Add-Ins regardless if they have been installed or not. The following screenshot demonstrates this behaviour. First, I loaded the Add-In “Test.xla” by opening the file with the file open dialog.


Continue…

Based on the results of my tools for comparing the VBA functions between Excel 2010, Excel 2007 and Excel 2003, I think the next logical step should be the systematic testing of new methods, events, properties, and constants.

Unfortunately, the documentation for the new VBA features is still incomplete on my installed version. However the purpose of some new features can often be guessed by their name. But I think this will not always be possible.

The last days, I took a look on the objects „Workbooks“, „Workbook“ und „AppEvents“. While I did not find changes for the workbooks collection, the „Workbook“ object includes some new events, methods and properties which seems to be very interesting.


Continue…

Microsoft Office also includes a global library, which you usually should find in the "Microsoft Shared\OfficeNN" folder of your Common Files folder. My tools retrieves the objects, methods, etc you can find in the downloadable file at the end of this post.


Continue…

I also scanned the different versions of MS Access and stored the results in an Excel file.


Continue…

Today, I have scanned the PowerPoint VBA Libraries for the versions 2010, 2007 and 2003 and exported the results to a separate Excel file, which you can download at the end of this article.


Continue…

I have now scanned the Word 2010, 2007 and 2003 VBA Libraries on my system and exported the results to a separate workbook. You will find the download link for this file at the end of this article.


Continue…

In my previous post „Excel VBA Type Library Scanner“, I had presented my application for scanning and parsing type libraries. However, my application needs the TLI Library „TlbInf32.dll“ to be installed and registered on the system where my application will run. For those people who do not want to install the TLI Library or have not access to it, I have now scanned the Excel 2010, 2007 and 2003 VBA Libraries on my system and exported the results to a separate workbook. You will find the download link for this file at the end of this article.


Continue…

In my article “The most important changes to VBA in Excel 2010“ from 08/05/2009, I had already reported about some changes to the VBA object model in Excel 2010. Also, I had started the development of an application for parsing and analysing all VBA objects, methods, properties and constants of the VBA libraries included in the Office apps. Just recently, I got the time to finish the development of this application.

The application is freeware and can be downloaded at the end of this article. The output tables are protected, however the password can be found in code which is unprotected and can be viewed by everyone. Please note, that the workbook itself and the copyright sheet are also protected by a password and this password is not publicly accessible.

The application referencies to the TLI Library „TlbInf32.dll“ in the windows system folder providing functions for scanning type libraires. Important note: the TLI Library needs to be installed and correctly registered on your system. My application can not work without this library. And please note that this library is not included in the download archive.


Continue…

Some people from my english speaking audience asked me a few days ago, if it may be possible to translate my german article published on 11/27/2009 about the comparison between the functions included in Excel 2003, 2007 and 2010. The file listing the functions of the different Excel versions is also presetted to English and can be downloaded at the end of this article. Below a screenshot from the worksheet:


Continue…

We have released the first version of the Excel Soccer World Cup 2010 Planner in English. This version includes the same functionality as the version available in German and in French. You can download the planner on following websites:

• www.en.excel-soccer-2010.de, English
• www.de.excel-soccer-2010.de, German
• www.fr.excel-soccer-2010.de, French

The Excel Soccer World Cup 2010 Planner has been primarly developed in Microsoft Excel 2003 and was also tested in Microsoft Excel 2007 and Microsoft Excel 2010. Please note that we will not support older versions of Excel and that other spread sheet software, like Open Office, were not considered.
Continue…

Recently, I found the download link for the „Office 2010 Developer Training Kit“ on Twitter and on the german blog from Tom Wendel. The Training Kit has been mainly created and tested by Paul Stubbs, Girish Raja, Steve Fox, Donovan Follette and Chris Mayo. As far as I know, the Training Kit is only available in English (I'm from Germany). The Training Kit provides many useful and interesting informations about Office 2010 and also exercises for developers.


Continue…

Do you also know this problem? When taking screenshots of an application for including the images in one of your blog posts, it is very often necessary to rescale the images so that they fit into the layout of the blog. However, after resizing the images, they become blurred and some texts illegible. The following picture, taken from Microsoft Excel 2010 in German, shows the problem.



In my first posts on this blog, I had uploaded two versions of the pictures. First, I created a smaller version of the original screenshot and then I linked to it in my article. Then I uploaded the picture in its original size and I added some JavaScript code to each previously inserted image link. The user then could view the larger picture by clicking on the smaller one. You may know, I'm also publishing my german articles on two other blogs, one blog is located on a Windows Live account and another one is a joint project with my good friend Andreas Entenmann, MVP for Excel. All three blogs are based on different systems. So, it was very time consuming to setup the JavaScripts for all blogs.
Continue…

While visiting my favourite blogs, I discovered the very interesting article „What is "Custom XML?" ... and the impact of the i4i judgment on Word“ from Gray Knowlton published on 23. December 2009. One day before, the U.S. Court of Appeals for the Federal Circuit upheld the trial court verdict rendered in favor of plaintiff i4i Limited Partnership and also upheld the permanent injunction issued against Microsoft barring future sales of Microsoft Word products containing the Custom XML features.



You can see the affected features of Word in question if you insert custom XML tags to your documents. They are made visible in the document by being highlighted in pink as shown in the screenshot above. The judgement will now have some impacts on these features in future versions of Word.
Continue…