Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Open Excel worksheet within PP slide

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chris46521 - 06 Jul 2006 20:56 GMT
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
HS Hartkamp - 12 Jul 2006 22:30 GMT
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.

> I am trying to create a slide in a PowerPoint presentation for
> management featuring a stationary Excel graph and a frame within the
[quoted text clipped - 6 lines]
> 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 - 12 Jul 2006 23:32 GMT
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

HS Hartkamp Wrote:
> With a bit of trickary, anything is possible:
> - Create a (very large) picture of the data
[quoted text clipped - 31 lines]
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=559061

Signature

chris46521

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.