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

David

FANTASTIC!

I've had a chance to look at the article in full and make use of the
proposed solution. It does exactly what I need it to do. I can now put the
WebBrowser control on my child form (or ideed an invisible panel on my main
form if I wish).

I very much appreciate your help with this solution.

Regards

Michael

"David Lloyd" wrote:

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



 
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 12:46 PM.

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"