Excel instance in VB.Net - as child of parent form

[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,

You are on the right newsgroup. This is not really my stuff but in the
weekend there are less active persons in these newsgroups.

Beside the 3 major dotNet developer newsgroups is there a 4th major
development newsgroup. In your case would I give it a try too there.

microsoft.public.excel.programming

I hope this helps something on your route.

Cor

 

[Paul Clement]

¤ 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)
¤

You should be able to use either the DSOFramer control or the WebBrowser control:

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

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


Paul
~~~~
Microsoft MVP (Visual Basic)