Open an Excel Workbook from either a BAT (or VBS) without pausing.
 

I am trying exec a BAT file with the contains:
==========
REM (call_XLS.BAT)
"example 1.xls"
exit
==========
But once it startes Excel, a command prompt window remains open until I
close Excel. Is there a way to have this close right away once Excel is
started?

I am actulay calling this from a PC REXX program and se no reason I could
not call the "example 1.xls" from a VBS file is that would be easier. I just
want Excel to open the Workbook without leaving the spawning window open.

Open an Excel Workbook from either a BAT (or VBS) without pausing.
 

I found some VBS commands that seem to so the trick except for it opens the
Workbook up as READ ONLY.

I created a file called example.vbs and in it is:

Dim XLApp
Set XLApp = CreateObject("Excel.Application")
xlapp.visible = true
xlapp.workbooks.open "sample.xls"

Is there a parm to add that opens this full mode instead of Read Only?

Open an Excel Workbook from either a BAT (or VBS) without paus
 

OK, I'm not sure why but when I was running the VBS, it was opening 2 copies
of example.xls. I was using the macro...

Sub Auto_Open()
' my code'
End Sub

and once I took this out, it starts the Excel fine (not Read Only).
I'll drop this thread and post me help for now correcting why I my "Auto"
macro is not right seperatly sence it no longet pertains to this Topic