Open Excel worksheet within PP slide

  • Thread starter Thread starter chris46521
  • Start date Start date
C

chris46521

I am trying to create a slide in a PowerPoint presentation fo
management featuring a stationary Excel graph and a frame within th
same slide displaying the actual Excel data set that can be scrolle
through in that frame. Does anyone know what VBA code I could use t
display a worksheet data set in the slide itself? There is a lot o
data, necessitating the need for a scroll bar in the frame. Linking th
Excel data into the slide by conventional methods will not work becaus
there is so much data it would not fit on the slide. I just need
small frame above the graph in which the Excel data can be scrolle
through. Thanks for any tips or suggestions that you may have
 
With a bit of trickary, anything is possible:
- Create a (very large) picture of the data
- Cover it with rectangles leaving a window open that shows the disired bits
(rectangles in the backgoundcolor of the slide)
- Create scrollbars along that window
- Set the x-y-position of the data (picture) according to the value of the
scrollbar.

Superimpose the rest of the slide on top of that.

Bas Hartkamp.


"chris46521" <[email protected]>
schreef in bericht
news:[email protected]...
 
Thanks for your reply! Can you tell me how to accomplish each step of
the process? I don't understand how to do it all.
Thanks, Chris
 
Back
Top