These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 13, 2011

Final Project - Kale Cabrinha

Qualtrics Panel Services connects Qualtrics users with partner panel providers to collect sample for their surveys. The projects are managed in-house by Qualtrics project managers. At the close of each project the project managers download a csv file with the panel id numbers for all the successful survey completions. The panel id numbers are unique to each panel provider and the column variable used to reference them in the spreadsheet is also different between providers. The downloaded file includes all the research data collected for that particular survey. The project manager needs to send back a file with the successful panel id numbers without compromising the privacy of the data collected. To do this the project manager will usually copy and paste the panel id column into a new worksheet and email that worksheet to the respective panel companies.

Since each panel id variable is different my solution prompts the user to specify the name of the panel id variable in an input box. It then copies all the variables into an array, creates a new workbook, and inserts the values of the array into the first column of sheet 1. A user form will prompt the user to select who the recipient of the email will be and sends an email with a form message to let the panel company know to close the project and attaches the created document of panel id numbers to the message.

No comments:

Post a Comment

Blog Archive