Printable View
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.
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.
No, no scroll bar things like that available. Hmm...
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.
Thanks Baron, I await with bated breath...