This all works fine except that I can't see more than the first page in the
OLE control. I've tried calling the PageScroll method like this

gfrmmain.OLE1.object.application.activedocument.activewindow.activepane.page
scroll down:=1

but I get an error which implies that the activepane is already scrolled to
the last page (if I call pagescroll up:=1 there is no error).

Any ideas from you experts/MVPs?

Hopefully,
Chris Jones

If you are unfamiliar with this control (which is actually the core of
Internet Explorer 4), please e-mail me direct and I would be happy to send
you a small example (Vb6 Pro SP1, IE 4.01 SP1, Word97 {8.0], Win95) which
manipulates a Word document in a WebBrowser Control. Even without Vb6,
perhaps you could get something out of it with a little of ye olde cut 'n'
paste. No Strings attached.

Barry Evans
Canberra, Australia
----------------------------

I'm building up a Word document from a form which shows the document
embedded in an OLE control on the same form.

This all works fine except that I can't see more than the first page in the
OLE control. I've tried calling the PageScroll method like this

gfrmmain.OLE1.object.application.activedocument.activewindow.activepane.page
scroll down:=1

but I get an error which implies that the activepane is already scrolled to
the last page (if I call pagescroll up:=1 there is no error).

Any ideas from you experts/MVPs?

Hopefully,
Chris Jones

However, I've been there using VB5.

VB5 SP3, IE4.01 SP1, Word97 (with the SR2 patches) and Win 95 or 98.

There are many little issues though!

I've also got it to run with IE 3 but there are different versions of the
web control which you have to use.

Yell out if this is the way you want to go and need help

Cheers

DiG

I think this must be the way to go.

I take it you have Word running as well and do all the document manipulation
by OLE automation, saving each change and refreshing the Browser at the same
time? Can you programmatically scroll the browser view of the document?

Thanks very much for the offers of help - after the frustration and
depression I got myself into yesterday trying to follow the MS KB advice on
scrolling Word docs in OLE controls this has made me feel my fresh and
optimistic self again.

Cheers guys
Chris

I second Barry's comments...  I've been there to!!!

However, I've been there using VB5.

VB5 SP3, IE4.01 SP1, Word97 (with the SR2 patches) and Win 95 or 98.

There are many little issues though!

I've also got it to run with IE 3 but there are different versions of the
web control which you have to use.

Yell out if this is the way you want to go and need help

Cheers

DiG

Despite the suggested solution for my Word doc display problems I still need
to display an Excel workbook in the OLE container control so that the user
can select stuff off it for pasting into the doc. I'm using the SizeMode =
AutoSize setting.

When the workbook is activated in place the OLE container control height and
width values include the interior of the document (the cells, chart etc) but
not the scrollbars and sheet selector tab that Excel very kindly adds to the
control. So the OLE container control as it appears on the form is larger
than it says it is. Anyone know how I can get the actual size of the
container? Maybe there's an API call I could use to retrieve the size of the
outer "frame".

TIA
Chris

Barry Evans
Canberra, Australia
-----------------------------

Despite the suggested solution for my Word doc display problems I still need
to display an Excel workbook in the OLE container control so that the user
can select stuff off it for pasting into the doc. I'm using the SizeMode =
AutoSize setting.

When the workbook is activated in place the OLE container control height and
width values include the interior of the document (the cells, chart etc) but
not the scrollbars and sheet selector tab that Excel very kindly adds to the
control. So the OLE container control as it appears on the form is larger
than it says it is. Anyone know how I can get the actual size of the
container? Maybe there's an API call I could use to retrieve the size of the
outer "frame".

TIA
Chris

Chris

At the risk of overkill, have you considered the WebBrowser Control as an
OLE container for your Excel workbook as well???

Barry Evans
Canberra, Australia
-----------------------------

Despite the suggested solution for my Word doc display problems I still need
to display an Excel workbook in the OLE container control so that the user
can select stuff off it for pasting into the doc. I'm using the SizeMode =
AutoSize setting.

When the workbook is activated in place the OLE container control height and
width values include the interior of the document (the cells, chart etc) but
not the scrollbars and sheet selector tab that Excel very kindly adds to the
control. So the OLE container control as it appears on the form is larger
than it says it is. Anyone know how I can get the actual size of the
container? Maybe there's an API call I could use to retrieve the size of the
outer "frame".

TIA
Chris