View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Lloyd[_3_] David Lloyd[_3_] is offline
external usenet poster
 
Posts: 37
Default Excel app as child form in VB.Net

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...b;en-us;304643

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

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


"mabond" wrote in message
...
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