Launch Excel from VB as a child of the running app 1

[Ctrant]

Is there anyway to launch an excel file from VB, but as a child of the running application (something similar to a child form)<br><br>Thanks,<br><br>Chris&nbsp;&nbsp;

 

[DougP]

IF so it would be and OLE (Object Linking and Embedding)object.<br>I'm sure there is something in help or MSDN<br>also check out the Knowledge base<br>

 

[Ctrant]

In regards to using OLE:<br><br>I've loaded the file using OLE and set the DOverb property to -4, which opens the excel file for editing within the form.&nbsp;&nbsp;The problem is that if the file is too large for the screen, the object does not provide any scroll bars, and there is no scroll bar property to set for the object.<br>

 

[Amiel]

<br><br>Kind of looks like this:<br><br><font color=red>Dim excel as Excel.Worksheet<br><br>set excel = CreateObject(&quot;Excel.Worksheet&quot</font><br><br>' Now you have an instance of an excel worksheet<br>' you can manuipiulate this guy in code as if it<br>' were an excel worksheet.<br><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>