keep object active 
Author Message
 keep object active

Hello,

I have written a script to create an excel object but
when I run it, it immediately disappears.  The only way i
can keep it visible and active is to put it "to sleep"
for however long I specify.  Is there a way to keep is
always open?

Here is my sample script:

Dim excel,xlsapp
Set xlsapp = CreateObject("Excel.Application")
Set excel = CreateObject("Excel.Sheet")
excel.Application.Visible = True
wscript.Sleep(1000)*5
excel.Application.Quit
Set excel = Nothing

Thanks in advance!

Dave



Sat, 16 Oct 2004 02:57:17 GMT  
 keep object active

Quote:
> I have written a script to create an excel object but
> when I run it, it immediately disappears.  The only way i
> can keep it visible and active is to put it "to sleep"
> for however long I specify.  Is there a way to keep is
> always open?

Dim xlsApp
Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
xlsApp.UserControl = True
Set xlsApp = Nothing

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--



Sat, 16 Oct 2004 03:19:54 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Active program: keeping the app active and checking time

2. Createobject keeps dll active

3. Keeping lines with controls while dragging the object - grouping objects

4. Keep document active while form runs

5. Keeping MS Access active

6. Keep grid selection hilited when form not active

7. How Do I Loop Midi Files OR keep another form active when they stop

8. s there any way to Keep the active logo like Netscape always at Right side

9. s there any way to Keep the active logo like Netscape always at Right side

10. Visual Basic: Keep Two Forms Active

11. keeping communicator active

12. How to keep secure website login active???

 

 
Powered by phpBB® Forum Software