ibgreat
08-12-2008, 03:31 PM
Hello all,
I am trying to design presentation that will allow interactive data analysis during the presentation. I assume importing and exporting from/to excel is the easiest way to do this as I would like to save the data after the presentation is over. For now an excel spreadsheet if fine, but later would like to be able to add the data directly to our database. Here is essentially what I am trying to do:
1. import staff names into a from xl into a table in the presentation
2. allow me to enter the answers to associated questions on the table
3. export the answers back to a new excel spreadsheet to store the data and calculate the results
4. the next slide would show the results
While I am somewhat familiar with VBA related to Access coding, I have never used it within Powerpoint or Excel so I am not familiar with the objects, etc. Any help or resources would be greatly appreciated.
I am trying to design presentation that will allow interactive data analysis during the presentation. I assume importing and exporting from/to excel is the easiest way to do this as I would like to save the data after the presentation is over. For now an excel spreadsheet if fine, but later would like to be able to add the data directly to our database. Here is essentially what I am trying to do:
1. import staff names into a from xl into a table in the presentation
2. allow me to enter the answers to associated questions on the table
3. export the answers back to a new excel spreadsheet to store the data and calculate the results
4. the next slide would show the results
While I am somewhat familiar with VBA related to Access coding, I have never used it within Powerpoint or Excel so I am not familiar with the objects, etc. Any help or resources would be greatly appreciated.