Solved

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

Posted on 2011-03-10
2
582 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 82

Accepted Solution

by:
oBdA earned 500 total points
Comment Utility
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
Comment Utility
Thank you so much!!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
noX challenge 17 75
allStar challenge 1 40
robocopy vs xcopy vs copy 8 53
silent install of security banner via msiexec command 4 45
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…
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now