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 » Categories » General

General

In the following, links to the articles I have published to the Excel-Ticker blog since the last post on this blog. And, I'm also happy to announce the next version of our Excel Soccer World Cup Planner for the Woman's World Cup next year in Germany. PS: oups, I have just seen that I forgot to link to the (older) articles for the calculations of large numbers in Excel, sorry.

• Announcement for the Excel Soccer Woman’s World Cup 2011 Planner
  After the great success of our free Excel Soccer World Cup 2010 Planner for the Soccer World Cup in South Africa this year with over 380,000 downloads and the great feedback, referrals and links from companies, bloggers and individuals, we feel happy to announce the Excel Soccer Woman’s World Cup 2011 Planner. The Woman’s World Cup takes place in Germany and will start on 06/26/2011 at 18:00 in Berlin with the match between Germany and Canada. (...)
• Group Policy for Microsoft Office 2010 eBook for free
  Microsoft has recently released the “Group Policy for Microsoft Office 2010” E-Book. The book is available for download as a Word, PDF or XPS document. The target groups are primarily IT professionals, consultants and administrators. The book is explaining on 259 pages the meaning and use of group policies and gives tips on planning and configurating Office 2010 deployements. Links to additional information are also provided. (...)
• Excel 2007 and 2010 Calendar for 2011 (FR-FR)
  We have released the French version of our multiple year calendar template for Excel 2007 and Excel 2010. The calendar includes the official holidays for France. However, due to some regional differences for the holidays, you may activate or deactivate some entries. (...)
• Overview of the Excel 2007 and Excel 2010 Calendar Templates for 2011
  Due to the numerous downloads of the calendar templates and as the download links are a little bit distributed through the blog posts, I thought, it may be a good idea to post an overview for all published versions of the calendar template. This post is also marked “sticky” in this category. So, this post will always be displayed on top when calling this category. I will update this post each time after a release of new versions or updates for the calendar. (...)
• Installation of Drupal 7 on a dedicated managed server from 1&1
  I am currently testing Drupal, a very mature and flexible content management system. Drupal is currently available in the stable version 6.19, which should be used for production systems. Drupal 7, which is currently in beta 3, brings a lot of new features and is definitely worth a test. (...)
• Calculation of very large numbers in Excel – Part 5 – Add-In
  This article presents my first version of my free Excel Add-In (Version 0.75 Build 151110) for calculating large numbers in Excel. The Add-In (you can download the file at the end of this article) currently implements functions for the addition, subtraction, multiplication and exponentiation of large numbers. The code in the Add-In is password protected; however you can unprotect the VBA project by using the password “excel-ticker” (without the quotes). Please also read the copyright notice and license terms in the last section of this article. (...)
• Calculation of very large numbers in Excel – Part 4 – Exponentiation
  This fourth part of my article series about the calculation of very large numbers in Excel talks about the exponentiation of two large numbers. If we consider the original problem (see my first article) which was the calculation of 80 ^200 in Excel, we will need at least from 80 ^ 160 an own algorithm. (...)
• Calculation of very large numbers in Excel – Part 3 – Multiplication
  In the last two articles, we have implemented two VBA functions for adding and subtracting two large numbers represented as strings. Now, it’s time to implement a function able to multiply two large numbers in a very fast way. The used algorithm for this purpose is the “Karatsuba algorithm”. I had already written an article about this algorithm on my blog on my software website, but I had not transferred the article to this blog. So, firstly some few words about the algorithm. (...)
• Calculation of very large numbers in Excel – Part 2 – Subtraction
  In the first article of this series, I presented a VBA function for adding two large numbers represented by strings. This article presents a function for performing a subtraction for two large numbers. This function will, like the adding function, split the numbers into blocks, do the subtraction and then reassemble the blocks. (...)
• Calculation of very large numbers in Excel – Part 1 – Addition
  Some time ago, there was a very interesting discussion in my favorite German “Office-Lösung” Office forum. A user asked, if it is possible to calculate the value of 80 ^ 200 in Excel. As the precision is limited in Excel to 15 digits, using an Excel formula will lead to result which will be cut from the 16th digit. And, because the default data types in VBA are also limited by their range of values, a simple function in VBA will not work. (...)

I am currently working on the relaunch of all my websites and blogs. A new, more intuitive and modern design is one of the targetted objectives. And, I will also change the technology behind my sites. The new system will be based on Drupal, which offers multidomain and mulitlanguage sites, social network components, blogs, forums and much more things. However, this means that I have to recreate and/or rewrite all content from my sites. Therefore, this is a project which cannot be realized in a few weeks but needs some more time. But we are on a good way.

In the future, until the relauch is finished, I will just publish an excerpt of my articles from my Excel-Ticker Blog. Following articles have been recently published.

• Excel 2007 and 2010 Calendar for 2011 (EN-US) – Update Version 1.10
  We have modified and improved the calendar by adding a new option for selecting the date format from a list. Common German, English and French date formats are include in the calendar. You can also add up to two user specific date formats to the resource sheet. (...)
• Excel 2007 and 2010 Calendar for 2011 (EN-US)
  Please note that I have modified the content of this article by adding the detailed description for the calendar and that I have shortened the article “Our contribution to the Microsoft 2011 Calendar Contest – US-Version” which previously included the description. The reason for this is that I would like to avoid confusions between the versions of the country specific calendars and want to keep in sync with the German and English articles.
  
  On the occasion, when developing the German version of the calendar, I have added some new features to the calendar and updated the US-Version. And I have also fixed some minor bugs and extended the holiday calculation algorithms. These algorithms automatically calculate the dates of the holidays for the selected year, both fixed to a date and relative to each other. So, in general, there is no need to reenter the holidays each year. (...)

I'm pleased to inform you that I am participating to the Microsoft 2011 Calendar Contest by providing an Excel multiple year calendar. As the contest is primarily focused on the US market, I have only included the official holidays for the United States in our template at this time. But I am planning to release localized versions for European countries as soon as possible. The calendar template includes a week, a month, a quarter and a year view. Sheets for entering notes and holidays have also been included as well as a sheet for individual settings for the calendar.

I have published a detailled description of the template on my Excel Ticker Blog.

If you like the calendar, it would be great, if you vote for it on the Office Website. Please note that the community filter may be set to “Unfiltered” and the category "Multiple-year Calendars" selected in order to display all available templates. The template presented here is named “Calendar including holidays and notes management”. Thanks :-)

Following new articles have been posted on the English version of my Excel Ticker blog.

• Create VBA Application Objects by using the Windows API
  Someone asked in the German Microsoft Answers Forum, if it is possible to get access to an Excel instance and then execute code from this instance. This gave me the idea to enumerate all open Excel instances by using the windows API and then try to access them with VBA. The article describes how to create VBA Application Objects using the Windows API. (...)
• Get the path and file name for a file location using formulas or VBA in Excel
  I am currently studying some Windows Registry accesses from Excel & Co. A formula in an Excel sheet helps me to split these entries into its components; meaning the path elements and the value. The location where a file is stored can be addressed in a similar manner like a registry key. So, I had the idea to write this article and use my formula for splitting a file location in its path and file name. (...)
• Automatically update an image from a web server in Excel
  A user asked in my favorite German forum “Office Lösung” about MS Office, if it is possible to automatically update an image from a web server in Excel. The user also posted some sample links and wished that the update should occur every minute. The images from the web server are sent to the browser as raw data and therefore no HTML code is used. (...)
• Create and use dynamic references to external files in Excel
  Someone asked in my favorite German forum about Microsoft Office if it is possible to dynamically build a reference to an Excel range located in another file. The following solution addresses a range in an external file by using the Excel functions OFFSET(), INDIRECT() and ADDRESS(). Let’s suppose, we have some files which all have an identical structure for the data. (...)
• Read and write Excel and other Office documents with PHP
  Sometimes, I also use PHP for implementing features for my websites. A very interesting and professional managed open source class library for reading and writing Excel documents in PHP is the “PHPExcel” project which can be found on CodePlex. (...)
• Disable the blog post publishing feature in Word 2010
  A user recently asked on the German Microsoft Office 2010 Forum the question whether and how the button “Publish as a blog post” can be turned off in Word 2010. This cannot be done in the Word 2010 options dialogue, but there is an option in the administrative templates for Word 2010. (...)
• Use own filename for the Normal.dot template in Word
  Most of my readers certainly know that, when creating a new document in Microsoft Word, the application generally uses the file “Nomal.dot” or “Normal.dotm” as template. But did you know that the filename can also be customized? (...)
• Using wildcards for searching text in Excel and PowerPivot
  While I was writing my part (PowerPivot) of an article about Microsoft Office 2010 for the German computer magazine “c’t” (issue 16/2010), I noticed that the DAX function “Search” apparently supports wildcards. However I did not find any explanations for the use of wildcards in this function on the online help website for PowerPivot. (...)

We have the pleasure to inform you that we have released the Version 2.00 Build 150510 of the Excel Soccer World Cup 2010 Planner. The new version contains some new features, which can be found in the version history on the download page of the website for the planner www.en.excel-soccer-2010.de.

As we added much more features to the planner and the add-on tool then planned, we have increased the announced version 1.75 to version 2.00.

However, we must unfortunately move the release date of the Add-On tool for the planner by one week to the 05/22/2010. This is mainly due to the following reasons. We would like to add a help file to the Add-On tool which also covers the Excel Soccer World Cup 2010 Planner. Writing the topics for the help file, creating the screenshots and translating the help file to English and French is much more work as planned. Also, we encountered in our tests for the tool some performance problem, which we would like to fix before publishing the tool. Finally, we have not completed all tests for the tool on other systems with the different languages. Thank you for your patience.

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…

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…

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…

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…

Microsoft Visual C# MVP Tim Dawson has - according the MVP Award Program Blog - developed the first ribbon user interface control for Silverlight web applications.

» Post at the MVP Award Program Blog
» Information about the produkt 'SandRibbon' at divelements
» Demo of the Ribbon Control at divelements


OfficePalooza is organizing a VBA challenge sponsored by Microsoft. The challenge begins on April, 20 and finishs on Mai, 1. Some prizes can also be won. Please read the official rules.

With the publication of our site in english, we are launching our blog. Principal subjects of our articles will be Microsoft Excel, VBA or VSTO. We look forward to any response, criticism and suggestions. As the operator of the blog, you can reach me at following address.

Address	:	Maninweb.de
		Mourad Louha
		Amstelbachstraße 20
		52134 Herzogenrath
		Germany
Fon	:	+49 2407 904 14 86
Mobile	:	+49 172 265 82 22
Mail	:
VAT Id	:	DE 244 113 868