Excel app as child form in VB.Net

[Guest]

Firstly I was advised not to crosspost ..... but was also advised that I
should post this question here after I had posted it elsewhere ....... so
apologies if I have broken the protocols again

I have an application (in vb.net) with a main form properties set to
mdiparent = true.
Toolbar button allows user to open an instance of Excel for work on a
particular file

dim xlApp as New Excel.Application
xlApp.Visible = true

' more code follows to open particular file etc

The Excel app opens in the normal way on users Desktop and my app is now
behind Excel

I want, specifically, to open Excel and have the instance contained within a
child window(form) within my app's main window

I know how to create the child window(form)

dim f as New frmxlApp
f.parent = me
f.show

But how do I get the instance of Excel to appear only in the window opened
as the child (f)

I've tried creating a custom control using the "com" object "Microsoft
Office Spreadsheet 9.0" but that only opens a spreadsheet window and does not
give me the full Excel functionality I need.

Does anyone have any ideas .... or, even better, solutions.

Using Windows XP, Visual Studio .NET 2003, .NET Framework 1.1 (SP1), Office
2000 (SP3)

Thanks and regards

Michael Bond

 

[David Lloyd]

Michael:

The following KB article proposes one alternative approach to this issue. I
do not know whether this will meet your needs, however, I thought I would
bring this to your attention.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304643

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Firstly I was advised not to crosspost ..... but was also advised that I
should post this question here after I had posted it elsewhere ....... so
apologies if I have broken the protocols again

I have an application (in vb.net) with a main form properties set to
mdiparent = true.
Toolbar button allows user to open an instance of Excel for work on a
particular file

dim xlApp as New Excel.Application
xlApp.Visible = true

' more code follows to open particular file etc

The Excel app opens in the normal way on users Desktop and my app is now
behind Excel

I want, specifically, to open Excel and have the instance contained within a
child window(form) within my app's main window

I know how to create the child window(form)

dim f as New frmxlApp
f.parent = me
f.show

But how do I get the instance of Excel to appear only in the window opened
as the child (f)

I've tried creating a custom control using the "com" object "Microsoft
Office Spreadsheet 9.0" but that only opens a spreadsheet window and does
not
give me the full Excel functionality I need.

Does anyone have any ideas .... or, even better, solutions.

Using Windows XP, Visual Studio .NET 2003, .NET Framework 1.1 (SP1), Office
2000 (SP3)

Thanks and regards

Michael Bond

 

[Guest]

David

Thanks for the link. It comprehensivly covers the issue i have a problem
with and looks as if it could offer a solution. I'll obviously know better
when I've done the necessary work, but on the strength of what i've read so
far I'm optimistic.

Thanks for taking the time to provide this for me.

Regards

Michael

 

[Guest]

David

FANTASTIC!

I've had a chance to look at the article in full and make use of the
proposed solution. It does exactly what I need it to do. I can now put the
WebBrowser control on my child form (or ideed an invisible panel on my main
form if I wish).

I very much appreciate your help with this solution.

Regards

Michael