Solved

Need help with bat file  to open Multiple Excel Worksheets without waiting on first to close

Posted on 2011-03-10
2
606 Views
Last Modified: 2012-08-14
Hi!  I'm trying to write a batch file to open multiple excel files.  The first one opens, but I have to close excel to get the second one to open, etc.  I want them to all open at once.  Can anyone help?  Here is what I have:

"R:\Time Tracking\Work Tracking.xls" &
"Z:\McCartney - Do Not Delete\Daily Tracking.xlsx" &
"Z:\CS Task Tracking - 2011.xlsm"

0
Comment
Question by:jam92102
2 Comments
 
LVL 84

Accepted Solution

by:
oBdA earned 500 total points
ID: 35097872
Simply use "start":

start "" "R:\Time Tracking\Work Tracking.xls"
start "" "Z:\McCartney - Do Not Delete\Daily Tracking.xlsx"
start "" "Z:\CS Task Tracking - 2011.xlsm"

Open in new window

0
 

Author Closing Comment

by:jam92102
ID: 35097894
Thank you so much!!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to get time difference in minutes and seconds only between 2 dates 2 46
T-SQL:  Sigh---Boy, this is fun.... 12 56
Query Syntax 17 41
Vector, list Questions R 6 30
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question