After I open the file holding the batch files they will open individually after each one is closed, and after third one closes the cmd page also needs to be closed
Just need a tweak so that they all open together and the cmd page closes automatically
Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: Intel(R) Core(TM) i5-3330 CPU @ 3.00GHz, Intel64 Family 6 Model 58 Stepping 9
Processor Count: 4
RAM: 8071 Mb
Graphics Card: Intel(R) HD Graphics, -1984 Mb
Hard Drives: C: 446 GB (183 GB Free); D: 931 GB (692 GB Free); F: 698 GB (268 GB Free);
Motherboard: Gigabyte Technology Co., Ltd., B75M-D3V
Antivirus: Norton 360, Enabled and Updated
Try this, copy and paste the code below into Notepad and save with .cmd extension :-
Code:
@echo off
for %%a in (
"C:\users\peter\desktop\A FILES FOR BACKUP\Copy of ROI mid Dec 2011 to 18 October 2011\8 ROI sheet Nov 2017 to Oct 2018.xls"
"C:\Users\peter\Desktop\3 spreadsheets\AGL ESTIMATED BILL.xls"
"C:\Users\peter\Documents\AllData\Dads\Mums Shares\My Budget includes payment to Michael\NEW sheet commenced 10717.xls"
) do (start "" "%%a")
Thanks again Managed.
Did as you suggested and got an error message(attached) when I tried to open the .cmd file containing your code.
I had tried Tools/options/general/ignore other applications, but nothing opened.
This is a real tester.
I might add that before I deleted Excel Launcher.exe command would open all three files and command window would close automatically.
Unfortunately,I cannot find the instructions for running Excel Launcher after installation (which I have done) .
Getting punchy with all my various attempts but I think I need to have a code which incorporates "consoleapplication.exe" and then use that code to enable Excel Launcher to be the default application rather than Excel.
See thread on https://forums.techguy.org/threads/assistance-with-launcher-exe-in-excel-2003.1230228/
This is the error message when I ran your code
It doesn't like the space, try putting 2 x double quotes like this :-
Code:
@echo off
for %%a in (
""C:\users\peter\desktop\A FILES FOR BACKUP\Copy of ROI mid Dec 2011 to 18 October 2011\8 ROI sheet Nov 2017 to Oct 2018.xls""
""C:\Users\peter\Desktop\3 spreadsheets\AGL ESTIMATED BILL.xls""
""C:\Users\peter\Documents\AllData\Dads\Mums Shares\My Budget includes payment to Michael\NEW sheet commenced 10717.xls""
) do (start "" "%%a")
If that doesn't work can you change the the paths and filenames so there are no spaces ?
Tried all suggestions and no luck.
Changed the path and put no spaces in everything I could as per
@echo off
for %%a in (""C:\users\peter\desktop\Oneinstancecommand\8ROIsheetNov 2017toOct2018.xls""
""C:\Users\peter\Desktop\Oneinstancecommand\AGLESTIMATEDBILL.xls""
""C:\Users\peter\Desktop\Oneinstancecommand\NEWsheetcommenced10717.xls "") do (start "" "%%a")
Managed, Have worked on this all day and am using this command
Start excel "C:\users\peter\desktop\A FILES FOR BACKUP\Copy of ROI mid Dec 2011 to 18 October 2011\8 ROI sheet Nov 2017 to Oct 2018.xls"
"C:\Users\peter\Desktop\3 spreadsheets\AGL ESTIMATED BILL.xls"
"C:\Users\peter\Documents\AllData\Dads\Mums Shares\My Budget includes payment to Michael\NEW sheet commenced 10717.xls"
Now when I run the command the first two (Copy of ROI..abd AGL..) open together with a blank excel sheet.
If I close the blank sheet it is replaced by the third sheet (NEW..)
This is very close to what I need so any suggestions welcome.
Thanks again
Start excel "C:\users\peter\desktop\A FILES FOR BACKUP\Copy of ROI mid Dec 2011 to 18 October 2011\8 ROI sheet Nov 2017 to Oct 2018.xls""C:\Users\peter\Desktop\3 spreadsheets\AGL ESTIMATED BILL.xls""C:\Users\peter\Documents\AllData\Dads\Mums Shares\My Budget includes payment to Michael\NEW sheet commenced 10717.xls"
(If/when you're sure it's working click on [Mark Solved] at the top of your page please).
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!