Export ActiveX text box powerpoint text to excel?

I am creating a powerpoint presentation to serve as an interactive product
catalogue that can be used at my company. I am trying to create an ActiveX
text box and a an additional button for someone to input information into the
text box and click some sort of marco-ed submit button and have the text
information sent to either a text file as a comma-delimited entry or to an
excel spreadsheet. Is it possible? Also, is there a way to clear out the
information in the text box after it has been entered so that someone new can
input their information? Also, is there a way for all of this to happen so
that successive entries do not overwrite in the text or excel file? I know
that is alot to handle but any help would be greatly appreciated.

In article , Greenguy wrote:
I am creating a powerpoint presentation to serve as an interactive product
catalogue that can be used at my company. I am trying to create an ActiveX
text box and a an additional button for someone to input information into the
text box and click some sort of marco-ed submit button and have the text
information sent to either a text file as a comma-delimited entry or to an
excel spreadsheet. Is it possible? Also, is there a way to clear out the
information in the text box after it has been entered so that someone new can
input their information? Also, is there a way for all of this to happen so
that successive entries do not overwrite in the text or excel file? I know
that is alot to handle but any help would be greatly appreciated.

It's all quite possible and probably not all that complicated, especially since
you've obviously thought out what you want in detail.

Here are the building blocks you'll need:

General-purpose routine for writing a string to a text file
http://www.pptfaq.com/FAQ00514.htm

You'll need to cobble the strings together into a properly formatted CSV string
before adding it to the file, of course, but that's just a matter of:

FinalString = Chr$(34) & StringOne & Chr$(34) & "," & Chr$(34) & StringTwo ...
etc

Here's some example code for manipulating the text in a text box.
To clear it, simply set the text to ""



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================