How to start excel from a batch file

jkpd2000 · May 10th, 2002, 04:24 PM

Hi ,

I have to open an excel file say RESULTS
from a batch file. because i am scheduling the batch file to run automatically.

Any thoughts.

NateO · May 10th, 2002, 04:30 PM

Don't know how to write the batch, might be thew wrong site...but have you considered starting xl automatically with the windows task scheduler?

jkpd2000 · May 10th, 2002, 04:32 PM

yes, it is opening excel with scheduler. but i want a specific file to be opened.

Nimrod · May 10th, 2002, 04:33 PM

In your batch file just call the specific file ie.

Code:

call results.xls

NateO · May 10th, 2002, 04:36 PM

Hi Nimrod. Is this how we write .bat files?

In any case, to open a certain file on XL launch, copy the file or a shortcut of the file and paste it in your xlstart folder. Should be on your c: drive. Give it a search.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-10 15:37 ]

Nimrod · May 10th, 2002, 04:40 PM

Hi NateO !
You write bat files in notepad or any other PlainText editor and then save with the extention ".bat".

Same concept as writing a Kix or vbs script ... only the commands and syntax are different.
ShortCuts are nothing more then one method of initiating a script... and there are many ways to initate scripts.

jkpd2000 · May 10th, 2002, 04:41 PM

nimrod,

Call results.xls is working. but i am getting enable macros popup which i dont want to be asked.

is there a way to suppress that

Nimrod · May 10th, 2002, 04:45 PM

Thru your toolbar ... tools...macro..security

_________________
NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.

[ This Message was edited by: Nimrod on 2002-05-10 15:45 ]

jkpd2000 · May 10th, 2002, 04:47 PM

thank everybody. its working

Nimrod · May 10th, 2002, 04:53 PM

Another cool thing that you can do is actually open a office app. AND start running a particular macro.... I'm not sure what the switch is in excel but in word it's /m
ie call word.exe /mMACRONAME

May 10th, 2002, 04:30 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Don't know how to write the batch, might be thew wrong site...but have you considered starting xl automatically with the windows task scheduler? __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

May 10th, 2002, 04:33 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	In your batch file just call the specific file ie. Code: call results.xls __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

May 10th, 2002, 04:40 PM	#6
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Hi NateO ! You write bat files in notepad or any other PlainText editor and then save with the extention ".bat". Same concept as writing a Kix or vbs script ... only the commands and syntax are different. ShortCuts are nothing more then one method of initiating a script... and there are many ways to initate scripts. __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 04:24 PM	#1
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	Hi , I have to open an excel file say RESULTS from a batch file. because i am scheduling the batch file to run automatically. Any thoughts.

May 10th, 2002, 04:32 PM	#3
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	yes, it is opening excel with scheduler. but i want a specific file to be opened.

May 10th, 2002, 04:36 PM	#5
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Hi Nimrod. Is this how we write .bat files? In any case, to open a certain file on XL launch, copy the file or a shortcut of the file and paste it in your xlstart folder. Should be on your c: drive. Give it a search. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-10 15:37 ]

May 10th, 2002, 04:41 PM	#7
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	nimrod, Call results.xls is working. but i am getting enable macros popup which i dont want to be asked. is there a way to suppress that

May 10th, 2002, 04:45 PM	#8
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Thru your toolbar ... tools...macro..security _________________ NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions. [ This Message was edited by: Nimrod on 2002-05-10 15:45 ]

May 10th, 2002, 04:47 PM	#9
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	thank everybody. its working

May 10th, 2002, 04:53 PM	#10
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Another cool thing that you can do is actually open a office app. AND start running a particular macro.... I'm not sure what the switch is in excel but in word it's /m ie call word.exe /mMACRONAME