LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Excel app as child form in VB.Net

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Parent child relation between two rows in an excel sheet Roshan Kumar Excel Worksheet Functions 2 May 9th 11 07:38 AM
Creating child worksheet from parent Vibeke Excel Worksheet Functions 7 July 9th 09 04:34 AM
Excel: How to import multiple XML "Repeating child elements" same. l8vj Excel Worksheet Functions 0 May 13th 06 12:52 AM
Sorting Parent Child kcmtnbiker Excel Worksheet Functions 2 March 31st 06 01:54 AM
child support calculator BrickYardFan Excel Discussion (Misc queries) 1 December 29th 04 03:17 AM


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"