473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 3299
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: mabond | last post by:
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...
6
by: Matthew Wieder | last post by:
I have the following requirements: Build a stand-alone C# application that asks the user to click in a cell in an Excel spreadsheet, and then displays the address of that cell in the C#...
3
by: Maheshkumar.R | last post by:
Hi groups, How i can command over the MDI CHIlD forms created dynamically at runtime from PARENT. Let say, i have generated 5 mdichild forms, but i want to work with child form1 from MDI...
10
by: Charles Law | last post by:
For some reason, when I click the X to close my MDI parent form, the action appears to be re-directed to one of the MDI child forms, and the parent remains open. I am then unable to close the...
3
by: Zack Sessions | last post by:
I am using VB.NET 2003. I have read the threads concerning the problem where the FormStartPosition of CenterParent is ignored if the form is displayed with the Show method as opposed to the...
0
by: mabond | last post by:
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...
10
by: John M. Gabriele | last post by:
The following short program fails: ----------------------- code ------------------------ #!/usr/bin/python class Parent( object ): def __init__( self ): self.x = 9 print "Inside...
4
by: Richard Lewis Haggard | last post by:
What is the mechanism by which a child window can notify its parent that it has been clicked on? -- Richard Lewis Haggard www.Haggard-And-Associates.com
0
by: Miro | last post by:
I searched google and I think I have solved the issue. Again, if someone could quickly skim over my example and lemmi know if it is the "correct" way of doing things. It works, but again - is it...
9
by: sitko | last post by:
Hi, I have an Order tracking spreadsheet that I need help with. I have a 2 worksheets "Open", and "Closed". I have entries on the "Open" sheet which may or may not be grouped together. I've...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.