Problems with integrating spreadsheet in Outlook forms

[Anne Kjersti Haveland]

Hi!

I am developing a form with the appointment form as basis. In a book I found
that it should be possible to embedd a spreadsheet - or any other Office
2007 application - into a Outlook form.
The way they describe to do this, is to right-click on the Toolbox, and
select Custom Controls. This opens the Additional Controls dialog box. And
in the list that appears here, you can select controls you want to appear in
the toolbox.

But in my list I can't find these controls. I find a lot of other controls,
but not these. I am running the Norwegian version, but have tried the
English version as well - with the same bad luck. Is there any way I can
find these?

Does this make sense at all? I am Norwegian, and my English is not the
best... I have tried the Norwegian Outlook news group, but got no help
there - so no I try you

Best regards
Anne Kjersti Haveland

 

[Hollis Paul]

Does this make sense at all? I am Norwegian, and my English is not the
best... I have tried the Norwegian Outlook news group, but got no help
there - so no I try you

Your English is just fine for the purposes at hand.

But in my list I can't find these controls. I find a lot of other controls,
but not these. I am running the Norwegian version, but have tried the
English version as well - with the same bad luck. Is there any way I can
find these?

There are tricks for finding the controls you want. The one used was to keep
a VB4 project defined on the same client box and set a reference to the dll
from which you wanted to extract the control. That reference would then
appear in the available list in Outlook. That was long ago, when Arienrohd
ruled the northern skies. Nowdays, you just have to open the VBA window, and
set the reference there. I used to have a terrible problem finding the dll
that had control I wanted, because the file name is not the same name as the
library name. Even though you know you want a control from the Common
Controls dll, you can have a difficult time picking the proper dll out of the
list that the reference setter presents.

Another thing you might do is open your spread sheet application, copy the
worksheet to the Windows clipboard, then open Outlook, and your form in design
mode, and do a paste special. The worksheet should then be live in your form.
It used to be quite difficult to bring it to life, but now, I believe, the
Paste Special command does it all automatically. Unfortunately, the Outlook
Help facility doesn't say much about Paste Special. You should trying going
to www.outlookcode.com and searching there for something about this subject.

 

[Anne Kjersti Haveland]

Thanks a lot!

Anne Kjersti

Your English is just fine for the purposes at hand.

There are tricks for finding the controls you want. The one used was to
keep
a VB4 project defined on the same client box and set a reference to the
dll
from which you wanted to extract the control. That reference would then
appear in the available list in Outlook. That was long ago, when
Arienrohd
ruled the northern skies. Nowdays, you just have to open the VBA window,
and
set the reference there. I used to have a terrible problem finding the
dll
that had control I wanted, because the file name is not the same name as
the
library name. Even though you know you want a control from the Common
Controls dll, you can have a difficult time picking the proper dll out of
the
list that the reference setter presents.

Another thing you might do is open your spread sheet application, copy the
worksheet to the Windows clipboard, then open Outlook, and your form in
design
mode, and do a paste special. The worksheet should then be live in your
form.
It used to be quite difficult to bring it to life, but now, I believe, the
Paste Special command does it all automatically. Unfortunately, the
Outlook
Help facility doesn't say much about Paste Special. You should trying
going
to www.outlookcode.com and searching there for something about this
subject.