This forum is for the discussion of Microsoft PowerPoint.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Excel and PowerPoint Link  Maurice Lubert      2 months ago 3 different topics: 1) I am now nearing the last of the Access Developer courses I have (Developer 13). I thought Id get the next ones automatically. apparently, I was wrong. So  I am pleased to order Developer 14 (and the coming ones as well). You have my credit card details. Read More... 2) I am presently building an interactive PowerPoint presentation heavily relying on VBA programming (which I had to learn from scratch in the world of PowerPoint. I have been programming for many years in Excel, but until your lessons in Access I had no idea something like this can be done in PowerPoint!). The presentation sends various data to Excel, where they are kept and analyzed  eventually, a report is sent back from Excel to PowerPoint. I have completed the main part of the presentation  including the sending of data to Excel (all this without the participation of the user, without even his very knowing such a collaboration exists), and I am now on the way back: analysis of the data in Excel, and their sending back to PowerPoint. Presently, I am stuck with various topics (such as running an Excel procedure from PowerPoint, or even assigning a formula to a range  where I have no problem in assigning a value). My question is: where can I find the needed help on the subject - the Internet is full of questions-and-answers on the inverse problem: talking with PowerPoint from Excel  it so appears the other way is much more esoteric. 3) Incidentally, I am now building a comprehensive Index of your courses (mainly based on your outline texts). I found it much easier to build the index in Excel, but the final product is a Word document (presently over 60 pages. If you have any interest in it, Ill be glad to send it to you when it is completed (a few more weeks). I cannot finish without saying that never in my not-too-short (83 years!) have I known such a sustained pleasure at learning anything as I have had with your lessons. Thank you so much Maurice Lubert Richard Rost     2 months ago Hi Maurice. Thank you so much for the kind words. Let me address your items. 1. You are on the Waiting List for Developer 15. I haven't processed Waiting List orders yet. I'll be doing that today. 2. To be completely honest, I've never done any work with integrations between Excel and PowerPoint. What you're doing sounds incredibly interesting, but I would be completely in your position and have to Google stuff myself. I've got some books here on MS Office Programming, but none of them really go into too much detail about Excel/PP combos. I'd suggest looking on Amazon to see if someone has written something like this. Googling stuff can sometimes be a maze. 3. Thank you so much. I've got the master index listed here: Access Index. I've been wanting to spend some time linking the different topics in the Index to the exact courses that the item is contained in (and maybe even jump to the time index) but that would be a LOT of work, and I've switched from the old Theater to the new way of posting classes right on the web site. So... I don't know how I'd handle that. But, I'd love to see what you put together. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

New PowerPoint Lessons Link  Richard Rost      4 months ago I know my Microsoft PowerPoint classes are in dire need of an update. The current ones are from 2003. There have been a LOT of changes in PowerPoint since then. Show of hands... who here is still interested in learning more PowerPoint? Post a comment here. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Live Excel data in presentation Link  Gioia      3 years ago Greetings! We have a PowerPoint presentation that runs off a TV monitor that serves as an info "kiosk" for our warehouse personnel. I've created a nice presentation that runs on a continuous loop and I update slides frequently. Currently we embedded an excel slide that is updated when the presentation is opened and the links refreshed. There is a 3rd party software (DataPoint) that claims to show live information in real time. Is there a way to do that using VBA? Did you already cover this in a class or seminar? Please advise. Thanks! Read More... Reply from Alex Hedley: Have you tried recording a macro and seeing what happens when you click the refresh data? LinkFormat.Update Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Show Older Comments...
View in Table Format