You have been working on looping through your MDD for a while now and your code is almost complete, you have a few things left on your list to resolve, one of them is “How do i loop the complex questions”. This article explains how to do this and hopefully shows you some very useful concepts that can be re-used.
Month: October 2008
How can I get the text for a category
You have been working on looping through your MDD for a while now and your
is almost complete, you have a few things left on your list to resolve, one of them is "Response.value returns a category number rather than the text, how , how can I get the response text". This article explains how to resolve this and hopefully shows you some very useful concepts that can be re-used.
Avoid Incrementing Quotas When Reviewing Interviews
Reviewing an interview causes the interview to be re-executed. This can cause quotas to be incremented if the interview and sample management scripts do not take this into account. The DDL example interviewing and sample management scripts for quota show how to avoid extra quota increments and should be used as a base.
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
List of All Excel Constants
This is a list of all the Excel constants
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.