Working with Forms, Application dissapears!!

[webstony]

Hello everybody,

I am working with Forms. When I press a button Excel shall start. But in the same moment it dissapears.

My Code:

Dim ExcApp As Object

Privat Sub Button1_Click()
Set ExcApp = CreateObject("Excel.Application&quot
ExcApp.Visible = True
End Sub

How can I achieve, that the Application does not disappear as long as the user does not quit it and the form is active.

cu, Stony

 

[ravenx]

ExcApp.UserControl = True

 

[ratman]

Consider this:

Sub openexcelman()
Dim x1 As Object
Set x1 = CreateObject("Excel.Application&quot
x1.Visible = True
End Sub


If this doesn't work email or if you want to talk email me at drat@mediaone.net

Ratman