Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Excel/Powerpoint - Chart size when linking | Excel Discussion (Misc queries) | |||
My ActiveX control does not respond when i draw it on a excell sheet, using ActiveSheet.OLEObject.Add | Excel Programming | |||
Excel sheet to Powerpoint slide | Excel Programming | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
OLEobject on the sheet | Excel Programming |