Rabu, 09 Mei 2012

[ExcelVBA] Re: Example of BAT file that starts EXCEL to Open a particular Workbook

 

My batch file does some User Name qualification stuff before it opens Excel with our Service Report workbook, then does some stuff after Excel is closed (primarily copying any newly created PDFs to our shared Dropbox folder)---I won't post all of that here. However, the line that opens Excel along with our Service Report workbook is very simple:

start /wait /max excel.exe C:\BN\IData\IData.xlsm

The /max parameter makes sure Excel opens full screen; the /wait parameter keeps the batch file from terminating after it executes the start function; when the user closes Excel the batch file continues executing whatever lines may be in your bat code.

--- In ExcelVBA@yahoogroups.com, "danielrose02" <dan.rose@...> wrote:
>
> Does anybody have an example of a BAT that starts EXCEL and opens a given (particular) Workbook?
>

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar