write to excel

[bernie dawson]

I am a teacher and I've written a quiz using powerpoint and some vba code -
thanks mainly to the Powerful Powerpoint book by David Marcovitz.
It asks 15 questions and records a tally of which questions were answered
correctly.
I want to send this to excel so that as the class uses it their scores are
written to excel
e.g.
Julie 110011
Tom 111000 etc
Thus it will be diagnostic for seeing which questions pupils found hard.
I've managed to do this to a text file, and can load this into excel,
but surely the text file can be bypassed?
Thus within powerpoint vba I need to know how to open up and create a new
excel file and write to it.
Bernie Dawson

 

[Steve Rindsberg]

I am a teacher and I've written a quiz using powerpoint and some vba code -
thanks mainly to the Powerful Powerpoint book by David Marcovitz.
It asks 15 questions and records a tally of which questions were answered
correctly.
I want to send this to excel so that as the class uses it their scores are
written to excel
e.g.
Julie 110011
Tom 111000 etc
Thus it will be diagnostic for seeing which questions pupils found hard.
I've managed to do this to a text file, and can load this into excel,
but surely the text file can be bypassed?
Thus within powerpoint vba I need to know how to open up and create a new
excel file and write to it.

Have a look here and the following pages:

Automating one app from another
http://www.rdpslides.com/pptfaq/index.html#name_Automating_one_app_from_another