I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word to
print off for students is a lengthly process, involving pasting each Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve

Should be doable with drop down boxes. Or, you could goto your list and
select each one and then copy/paste the selected rows..

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve the Pirate" <Steve the wrote in
message ...
I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word
to
print off for students is a lengthly process, involving pasting each
Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export
that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve

why not create a macro that allows for you to click on the questions you want
and have those exported. you could have the macro called with a button.

questions 1-6, 7 12 15 ...etc
button click and the questions get exported to word. or is that not possible?

"Don Guillett" wrote:

Should be doable with drop down boxes. Or, you could goto your list and
select each one and then copy/paste the selected rows..

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve the Pirate" <Steve the wrote in
message ...
I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word
to
print off for students is a lengthly process, involving pasting each
Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export
that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve

.

why not create a macro that allows you to click on the questions you want to
export and then have a button call the macro. That way you could click on
questions 1-6, 7, 9 , 12 etc and then click a button to have the questions
export to word? or is that not possible?



"Steve the Pirate" wrote:

I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word to
print off for students is a lengthly process, involving pasting each Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve

Hi
Have you thought about shifting to Moodle?
Here is a free Excel to GIFT converter (GIFT is a Moodle question
format).

http://moodle.org/mod/forum/discuss.php?d=45245

Go into the Moodle site as a guest if you are asked to login.
I can send you a document on creating Moodle multichoice quizzes if
you email me. In Moodle, you can put your questions in categories,
then lift out a number from each (a random selection and randomized
answers if you wish) to build your test.
The only question then would be delivery - do you have a server and
PC's to deliver an online test.

regards
Paul


On Jan 11, 2:59*pm, Steve the Pirate <Steve the
wrote:
I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word to
print off for students is a lengthly process, involving pasting each Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve