views:

864

answers:

3
+2  Q: 

VBA in PowerPoint

Could anyone recommend me a good online guide to PowerPoint VBA? Else, does anyone has advice on how to record a macro in PowerPoint? Thanks!

A: 

Can you describe what you are hoping to accomplish? There are dozens of VBA books out there for Word, Excel, etc. but "programming" in PowerPoint is not so common.

Here's a brief online "FAQ" for the newcommer:

http://skp.mvps.org/index.html#newbie

and a general howto:

http://www.pptfaq.com/FAQ00033.htm

scunliffe
+2  A: 

To record a powerpoint macro:

  1. In the menu bar, click on Tools
  2. Mouse over Macro > and the submenu will be displayed
  3. Click the Record button - a new toolbar will be displayed
  4. Do your thing
  5. Click the stop button on the new macro toolbar

Click on Tools->Macro->Macros. Find the macro you just recorded and click the Edit button. That will show you what was recorded. Make your modifications and click the triangular run button (or push F5) to run your code.

As far as an online guide, I usually think of a question and use Google or ask a question here on StackOverflow.com. I've been able to answer most of my questions that way, I haven't found a particular main resource for all things Powerpoint VBA.

Also, you can find answers that can help you by looking into VBA articles for other MS Office products - a lot of things that are not Powerpoint-specific (general VBA) will be the same as for the other products.

Knobloch
A: 

Thanks for the answers.. I am searching to update an embedded powerpoint presentation with data from another workbook. I have found various types through research in google (like how to update graphs) but I am searching for a more general guide.. Indeed not there is not much information on Powerpoint VBA