How to use GetMrData.xls

GetMrData.xls has been around for as long as we can remember, but how many of you know about it ? In the article we will show you how to use it and get your data into an excel file. Yes you can export directly out of Data collection to do this directly, but with this file and some customization you could make it do allot more than just that.

Read more

Show all Excel constants

It is often very useful to have a list of all the constants that are used in Excel 2003. One way to get a list is to search the web, but you can produce such a list yourself. All you have to make sure is that you have the following DLL installed TlbInf32.dll. If you don’t have it, search the web and you will find. Once installed create a new mrs file and add the following code

Read more

Finding the value of EXCEL constants

When you write scripts that utilise Microsoft Excel objects you will definitely come across the need to understand some of the numeric values that are stored as Excel Constants. There are several ways you can find out these values and this article provides you with two ways to do that. Before we get started we need to have some excel code.

Read more

Table of Contents for Excel Tables

Ever wish that the tables export to Excel would create a table of contents?  Ever wish for sheet names based other than T1, T2, etc.?  This post discusses a Dimensions script that creates a Table of Contents sheet, optionally creates links back to the TOC sheet on each table/chart sheet and optionally renames the sheets based on a row in the sheet.

Read more