Open Excel worksheet within PP slide

I am trying to create a slide in a PowerPoint presentation for management featuring a stationary Excel graph and a frame within the same slide displaying the actual Excel data set that can be scrolled through in that frame. Does anyone know what VBA code I could use to display a worksheet data set in the slide itself? There is a lot of data, necessitating the need for a scroll bar in the frame. Linking the Excel data into the slide by conventional methods will not work because there is so much data it would not fit on the slide. I just need a small frame above the graph in which the Excel data can be scrolled 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]...
>
> I am trying to create a slide in a PowerPoint presentation for
> management featuring a stationary Excel graph and a frame within the
> same slide displaying the actual Excel data set that can be scrolled
> through in that frame. Does anyone know what VBA code I could use to
> display a worksheet data set in the slide itself? There is a lot of
> data, necessitating the need for a scroll bar in the frame. Linking the
> Excel data into the slide by conventional methods will not work because
> there is so much data it would not fit on the slide. I just need a
> small frame above the graph in which the Excel data can be scrolled
> through. Thanks for any tips or suggestions that you may have.
>
>
> --
> chris46521
> ------------------------------------------------------------------------
> chris46521's Profile:
> http://www.excelforum.com/member.php...o&userid=35909
> View this thread: http://www.excelforum.com/showthread...hreadid=559061
>

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

Originally Posted by HS Hartkamp

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]...
>
> I am trying to create a slide in a PowerPoint presentation for
> management featuring a stationary Excel graph and a frame within the
> same slide displaying the actual Excel data set that can be scrolled
> through in that frame. Does anyone know what VBA code I could use to
> display a worksheet data set in the slide itself? There is a lot of
> data, necessitating the need for a scroll bar in the frame. Linking the
> Excel data into the slide by conventional methods will not work because
> there is so much data it would not fit on the slide. I just need a
> small frame above the graph in which the Excel data can be scrolled
> through. Thanks for any tips or suggestions that you may have.
>
>
> --
> chris46521
> ------------------------------------------------------------------------
> chris46521's Profile:
> http://www.excelforum.com/member.php...o&userid=35909
> View this thread: http://www.excelforum.com/showthread...hreadid=559061
>