View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarkChapin MarkChapin is offline
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