write to excel

  • Thread starter Thread starter bernie dawson
  • Start date Start date
B

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
 
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.
Click to expand...

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
 
Back
Top