Hi all ye gurus!
I've coded a VB app with a form with an embedded OLE object, which I dynamically turn into an Excel spreadsheet. The only problem is that after I've populated and formatted the sheet, I'd like it to at least fill the entire container window, not just 10 rows. If I double-click, then double-click again on the object handle, it auto-sizes quite nicely, but it'd be much nicer if I could do it via the VB code. MUCH nicer... ;-) (I also get two more columns than I need, but I figure I'll be able to solve that one once I get the answer on the rows...)
/Cy
I've coded a VB app with a form with an embedded OLE object, which I dynamically turn into an Excel spreadsheet. The only problem is that after I've populated and formatted the sheet, I'd like it to at least fill the entire container window, not just 10 rows. If I double-click, then double-click again on the object handle, it auto-sizes quite nicely, but it'd be much nicer if I could do it via the VB code. MUCH nicer... ;-) (I also get two more columns than I need, but I figure I'll be able to solve that one once I get the answer on the rows...)
/Cy
