Make Excel Visible

[AlexIT]

Following up to a previous question I had, when I wshell.run "c:\test.xls" I create an instance of Excel that is not visible...in VBA I would add an oExcel.Visible=True. How do I do this in vbscript??

Thanks,
Alex

 

[mrmovie]

you would need to bind to the instance of Excel that is running and use the same .Visible property

 

[tsuji]

If you need more control or just to open up an xls file in the interface for users to interact with it, you can always do it simply like this.
[tt]
[green]xlfile="d:\test\xyz.xls"[/green]
set oxl=createobject("excel.application")
oxl.visible=true
oxl.workbooks.open xlfile
set oxl=nothing
[/tt]