Running Excel app as child form in Vb.net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
mabond,

Try to avoid multiposting, crosspost, the advance from that is that we all
learn from the answers and we can see if there is already a properiate
answer given on the question.

While often seen multiposted answers get no answer because it can be a waste
of time, because it is already answered in another newsgroup that we don't
see.

(crossposting is sending one message to more relevant newsgroups)

Thanks in advance

Cor
 
Back
Top