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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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