Linked Excel worksheet
Posted on 1998-06-23
I have added a linked OLE object to a form and the source document is an Excel spreadsheet. the spreadsheet is dynamic and will grow in length. Can someone tell me how to have the rows set themselves automatically? I need to set set a scrollable viewport for the data. I tried adding a Vscrollbar to my form but all that does is scroll the entire OLE box. How do I anchor the box and scroll the Data.