Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel sheet size as OLEObject in Powerpoint

I want to automatically add an excel sheet to a powerpoint slide. If I open
excel, and copy/paste a specific range, it looks fine. If I use VB or access
the AddOLEObject method through an ActiveX server, I can't figure out how to
change the range the user sees in Powerpoint. My sheet has many columns, but
I only want the user to see columns A:J, for example. The AddOLEObject
method make many more columns visible.

I've tried setting the Height/Width property but it only rescale the size,
it doesn't change the sheet range that is seen.

Does anyone know how to change this property?

This is my ActiveX version, I'm using Matlab. I can see all the
method/prorerties as I see in VB.


xls=new_slide.Shapes.AddOLEObject(10,10,-1,-1,'',fn,0,'msoFalse',0,'',0);

VB code examples are OK.

Mark

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Excel/Powerpoint - Chart size when linking Kathy at M/A/R/C Excel Discussion (Misc queries) 0 March 9th 09 06:31 PM
My ActiveX control does not respond when i draw it on a excell sheet, using ActiveSheet.OLEObject.Add Nikhil Joshi[_2_] Excel Programming 0 August 11th 06 02:57 PM
Excel sheet to Powerpoint slide Herve Excel Programming 1 December 8th 05 04:04 PM
How to get the size of the excel file, a sheet size (in bytes)? bookworm98[_13_] Excel Programming 1 January 28th 04 02:59 PM
OLEobject on the sheet Ryan[_6_] Excel Programming 1 August 3rd 03 03:15 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"