Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel pausing | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |