HI,
I am a newbie at excel programming, I am using Office 2010. I was able to successfully embed an excel workbook on powerpoint. I wanted to ask about controlling the number of rows visible on the embedded excel workbook. I had tried resizing the handles on the OLE object but it resizes the objects but still shows the same number of rows. Please advise. I have attached a picture of the current scenario. I am using this code to embed the object.
Set ppShape = ppSlide.Shapes.AddOLEObject(Left:=50, Top:=50, Width:=600, Height:=500, Filename:=".xls", displayasicon:=msoFalse)
If picture is not visible, please click on the link below.
https://docs.google.com/file/d/0B2UFfugYGdv8ckEtS1lkR1FIWXM/edit?usp=sharing
Thanks,
Aura
I am a newbie at excel programming, I am using Office 2010. I was able to successfully embed an excel workbook on powerpoint. I wanted to ask about controlling the number of rows visible on the embedded excel workbook. I had tried resizing the handles on the OLE object but it resizes the objects but still shows the same number of rows. Please advise. I have attached a picture of the current scenario. I am using this code to embed the object.
Set ppShape = ppSlide.Shapes.AddOLEObject(Left:=50, Top:=50, Width:=600, Height:=500, Filename:=".xls", displayasicon:=msoFalse)
If picture is not visible, please click on the link below.
https://docs.google.com/file/d/0B2UFfugYGdv8ckEtS1lkR1FIWXM/edit?usp=sharing
Thanks,
Aura
Last edited:
