Help Exporting Powerpoint ActiveX TextBox

[Khadafi]

Hi, I am creating a questionnaire on powerpoint, the answers given are sent
to a summary page at the end of the presentation using vba coding. I have got
this working perfectly.
I want to store the answers on the summary page on either excel or access, I
have tried using various macros which saves text in normal text boxes as a
csv file, but as the text boxes on the summary page are active x ones, the
text is not saved.
Any help would be much appreciated.
Many thanks.

 

[John Wilson]

Post the code you have that works with normal textboxes and I'm sure someone
will adapt it for you.

 

[John Wilson]

Just a further thought, from your description maybe you don't need activX
textboxes on the summary slide?
--
john ATSIGN PPTAlchemy.co.uk

Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html

 

[Matti Vuori]

Hi, I am creating a questionnaire on powerpoint, the answers given are
sent to a summary page at the end of the presentation using vba
coding. I have got this working perfectly.
I want to store the answers on the summary page on either excel or
access, I have tried using various macros which saves text in normal
text boxes as a csv file, but as the text boxes on the summary page
are active x ones, the text is not saved.

I didn't even know that PPT has "normal" textboxes that are not ActiveX
controls...

Each ActiveX control of type TextBox has a property Text which has the text
of the textbox (for example: textbox1.Text).