G
Guest
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
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