471,066 Members | 1,552 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

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

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
Nov 21 '05 #1
3 3108
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
Nov 21 '05 #2
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
Nov 21 '05 #3
On Fri, 9 Sep 2005 14:43:01 -0700, mabond <ma****@discussions.microsoft.com> wrote:

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

http://support.microsoft.com/default...b;en-us;304643
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Matthew Wieder | last post: by
3 posts views Thread by Maheshkumar.R | last post: by
3 posts views Thread by Zack Sessions | last post: by
10 posts views Thread by John M. Gabriele | last post: by
4 posts views Thread by Richard Lewis Haggard | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.