• Home
• Contact
• Imprint

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

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. (...)