In this series of articles we will look at the most common bits of vba that you will need to know about to write scripts using data collection. Once you have the basics we will then look at how we can use these new skills in conjunction with everything else.
Month: November 2010
Customising GetMrData.xls ( Split Data Across Sheets )
In a recent coment we where asked by Nathan to change the
so that when the get data section is run it spreads the data across multiple sheets. Having the data all on one sheet can be a problem in older versions of excel, as you are limited to a certain amount of columns. This article provides you with this updated
and explains how it is done.
Customising GetMrData.xls
In our last post we showed you how to use GetMrData.xls and get your data into excel. In this post we will show you how to customize it so that after you have changed a record you can click a button and send the update back to the data file.
Q & A: Setting the answer of a multiple response question.
Question:
I have this multiple response question and I want certain selections to be
'thicked' automatically. If I type in the script
Question.Response.Value="Choice2"
the only first one is selected but others are not. If I type
Question.Response.Value="Choice2, Choice3"
it does not work
Answer:
Metadata(en-AU, Question, label)
Q1 "Question_Text_Goes_Here" categorical [1..]
{
A,B,C,D,E
};
End Metadata
Routing(Web)
Q1 = {A,E}
Q1.Show()
End Routing
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.
Quick Post : Product Map
Still confused about what product is what ? Well we are not surprised a while back Sam Winstanley wrote a blog article on it. With the release of version 6 and the acquisition of SPSS by IBM the names have changed again slightly, to help you and us figure it out you can see a product map here.
Loading a card column file into Excel
In this article we are going to show you how you might change a quantum output file into something that can be loaded up into Excel. You might want to do this if you just want to look at the data file.