Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pausing BAR Excel Discussion (Misc queries) 0 January 27th 10 09:57 PM
Opening Excel, Book1 opens, remains open with other workbook open DanieB Excel Discussion (Misc queries) 0 September 3rd 09 08:23 AM
excel 2003 saved file will not open without a blank workbook open Bob Excel Discussion (Misc queries) 4 November 11th 06 04:24 PM
Excel workbook does not open in open window on desktop DeanH Excel Discussion (Misc queries) 2 March 8th 05 09:51 AM
Open a password protected excel workbook from second workbook to fetch data using dynamic connection kaustav choudhury Excel Programming 2 April 3rd 04 06:18 AM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"