Hello all,
I have a OLE control linked to an Excel Workbook file and it displays the active worksheet quite nicely. I have the SizeMode property set to 2-AutoSize. However, the control cuts the file off at the same position each time. I have even tried to change the height at runtime as well as changing the AutoSize property and manually setting the height before I run the program. All I get then is the same amount of rows as when it was in AutoSize and empty white space following that where there should have been more rows from the Excel file. Any ideas what might be causing this?
Thanks,
PJ
I have a OLE control linked to an Excel Workbook file and it displays the active worksheet quite nicely. I have the SizeMode property set to 2-AutoSize. However, the control cuts the file off at the same position each time. I have even tried to change the height at runtime as well as changing the AutoSize property and manually setting the height before I run the program. All I get then is the same amount of rows as when it was in AutoSize and empty white space following that where there should have been more rows from the Excel file. Any ideas what might be causing this?
Thanks,
PJ