Running Excel app as child form in Vb.net

[Guest]

Firstly I hope I'm in the right forum ..... if not can someone re-direct me
please.

I have an application 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

 

[Cor Ligthert [MVP]]

mabond,

Try to avoid multiposting, crosspost, the advance from that is that we all
learn from the answers and we can see if there is already a properiate
answer given on the question.

While often seen multiposted answers get no answer because it can be a waste
of time, because it is already answered in another newsgroup that we don't
see.

(crossposting is sending one message to more relevant newsgroups)

Thanks in advance

Cor