OLE control sizing

[blweb]

I am trying to control the size of the excel sheet that comes up from the OLE object in VB6.

I have put the control in a frame so that it doesn't autosize across the entire form. When I tell it to zoom or stretch to the size of the ole control, the width and height set themselves right, but the text in the sheet becomes so tiny and unreadable. If I tell it to act normally, the text is readable and the correct size, but the borders and all navigational thing (ie scrollbars and sheet tabs) are cut off the sheet due to size.

The property (.sizemode) isn't doing the trick. Does anyone have any ideas?

blweb

 

[blweb]

can anyone even give me a guess on this?

 

[sub1700]

I am also having this problem and I was wondering if you had come across an answer yet.

Thanks,
PJ