garywood84
06-09-2007, 05:41 PM
I have some PowerPoint slides which have form controls on them (i.e. text boxes and radio buttons). Is it possible to link these to an Excel sheet and copy the values to it?
Here's what I'm trying to do. I'm doing a survey which will present respondents with pictures and they'll be asked to choose one. Say they choose picture A, then I want an A to appear in cell A1 of an Excel sheet. Then, for the next picture, they might choose B, so B should appear in cell A2...and so on through all the slides.
To complicate things just a little bit more, the next participant's responses should go in the same Excel sheet, just starting from the next blank row. That is, if there are ten slides, participant 2's responses will be in rows 11-20.
I know this is very complicated and am not sure it's possible, but if anyone can help, I'll be very grateful.
Thanks,
Gary
Here's what I'm trying to do. I'm doing a survey which will present respondents with pictures and they'll be asked to choose one. Say they choose picture A, then I want an A to appear in cell A1 of an Excel sheet. Then, for the next picture, they might choose B, so B should appear in cell A2...and so on through all the slides.
To complicate things just a little bit more, the next participant's responses should go in the same Excel sheet, just starting from the next blank row. That is, if there are ten slides, participant 2's responses will be in rows 11-20.
I know this is very complicated and am not sure it's possible, but if anyone can help, I'll be very grateful.
Thanks,
Gary