Dynamic Hotspots in Powerpoint

[Laura]

Our company uses LotusScript to automatically export information from
a Lotus Notes Database into a PowerPoint Presentation with the click
of a button. When the user clicks the button, information is
automatically exported into an Excel spreadsheet, and then
automatically embedded as a picture into a Powerpoint Presentation
(using AddOLEObject). This is working correctly.

The users now want to automatically add hotspots to the Powerpoint
Presentation so they can click on the Powerpoint Presentation to
optionally get more information. The hotspots would appear in
Powerpoint, but would correspond to each line in the Excel
Spreadsheet. The additional information for the hotspots exists in the
Lotus Notes Database. We could automatically export the additional
information into other Excel Spreadsheets. The issue is how to
automatically create these dynamic, changing hotspots in Powerpoint.
Also how do we specify this hotspot to open another page? All of this
would need to be automatic behind a button in Lotus Notes.

Does anyone know the methods I would call to automatically create
these dynamic hotspots?

Does anyone know of another way that might work better?

Is there a forum to which I should post that would be better suited
for this question?

Thank you for your time and help.

Laura

 

[Steve Rindsberg]

I'd start by doing manually whatever it is you want PPT to do automatically.
Once you've worked out exactly what that is, do it with the macro recorder
running.
That won't likely give you finished useful results, but it'll get you headed
in the right direction.

Then c'mon back with any roadblocks you run into.

--

Steve Rindsberg PPT MVP
PPTLive ( http://www.pptlive.com ) Featured Speaker
PPTools: http://www.pptools.com
PPT FAQ: http://www.pptfaq.com