OLE Linked

[coox]

I've painted a little OLE thing on my form, set it up as a "Create New" Excel worksheet. Then in the Form_Load I've put:

OLE1.CreateLink "C:\Windows\Desktop\Fred.xls"

and when the thing loads I can see the contents of dear old Fred.xls. Guuurrreeat. Now, can I get the thing to scroll? I mean, supposing I don't want to forever be looking at the top left part of the sheet.

[Baron_Fel]

I'm doing this out of my head (I don't even HAVE Excel) but I think there should be a Scroll property or something like that. Something that says 0-None, 1- Vertical, 2-Horizontal, 3-Both or something like that.

[coox]

No, no scroll bar things like that available. Hmm...

[Baron_Fel]

I'm not sure how the Excel spreadsheets are set up but you could try a manual scroll bar...I'll go look if I have any spreadsheet controls on my comp and try them with a manual scrollbar.

[coox]

Thanks Baron, I await with bated breath...