• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 964
  • Last Modified:

Auto-run Macro on opening PowerPoint

Hello!

I have created a macro in PowerPoint to update slides with external data.  I'd like this macro to run automatically upon opening the file but don't see how to do that.

Could someone please enlighten me?

Thanks.
0
xfvgdrthbdtyvhgscv
Asked:
xfvgdrthbdtyvhgscv
  • 3
1 Solution
 
Anne TroyEast Coast ManagerCommented:
Not happening.
PowerPoint doesn't provide for any auto macros.
:(
0
 
Anne TroyEast Coast ManagerCommented:
What is the external data?
There are several pretty good Google hits:

Graphs don't update:
http://www.rdpslides.com/pptfaq/FAQ00025.htm

Similar:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;qQ267974
0
 
Jeroen RosinkSoftware testing consultantCommented:
Hello xfvgdrthbdtyvhgscv,

perhaps this might help you. Its about how to reset slides etc. You might put your code in the example.

PPT2000: How to Use VBA Events to Reset Slide Builds
http://support.microsoft.com/default.aspx?scid=kb;en-us;276353

regards,

Jeroen
0
 
xfvgdrthbdtyvhgscvAuthor Commented:
Dreamboat,

Thanks.  Saved me a bunch of time trying to do the impossible.  The Excel paste-in example helps too.  My external data source is going to be a form on a web page.  I've found, built, and successfully tested, VBA to open an IE window fro within a PPT macro, and direct that window to my data source url.  I'm going to read the form values on the page and paste them into the tables of the charts in the presentation slides.

Since I can't have the macro auto-run, I'll put a button object on the first slide marked "Click me to update presentation" which will launch the macro - or so PPT help says I can, haven't tried it yet.

I have been unable to get PPT to record a macro of replacing chart table cell values and don't much relish coding it all by hand because there are are over a hundred slides.  I'll open a new 500 point question on that, if you're interested.

Roos - thanks anyway for the input.
0
 
Anne TroyEast Coast ManagerCommented:
Happy to help.
I'm no coder.
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now