• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

How to code a batch file?

E

Eric

Flightless Bird
Does anyone have any suggestions on how to code a batch file to open an excel
file if current time is between 9 am and 10 am? otherwise don't open it.
Thanks in advance for any suggestions
Eric
 
M

Mint

Flightless Bird
On Mar 25, 8:37 pm, Eric <E...@discussions.microsoft.com> wrote:
> Does anyone have any suggestions on how to code a batch file to open an excel
> file if current time is between 9 am and 10 am? otherwise don't open it.
> Thanks in advance for any suggestions
> Eric

I would try this group.

Andy

http://groups.google.com/group/alt.msdos.batch.nt?hl=en
 
P

PA Bear [MS MVP]

Flightless Bird
Are you ever going to reply to any of your other recent threads?

http://groups.google.com/group/micr...er.general/browse_frm/thread/e6de782e8f403bca

http://groups.google.com/group/micr...ookexpress/browse_frm/thread/2a1b1cfb1279b2c5

http://groups.google.com/group/microsoft.public.windowsupdate/browse_frm/thread/4e3d8245bd70e86b

http://groups.google.com/group/microsoft.public.outlook.general/browse_frm/thread/cb077cda81a7050

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/819b3239e484c35e

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/2e56d13ea6909ba

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/f72133be50537cdd

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/e59fb677d4df2efe
--
~PA Bear

Eric wrote:
> Does anyone have any suggestions on how to code a batch file to open an
> excel file if current time is between 9 am and 10 am? otherwise don't open
> it. Thanks in advance for any suggestions
> Eric
 
J

John John - MVP

Flightless Bird
Eric wrote:
> Does anyone have any suggestions on how to code a batch file to open an excel
> file if current time is between 9 am and 10 am? otherwise don't open it.
> Thanks in advance for any suggestions

Here you go:

=======================================================================
@echo off
for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
if /i %tm% LSS 900 goto eof
if /i %tm% GTR 1000 goto eof
"x:/Data Folder\FileName.xls"

=======================================================================

John
 
E

Eric

Flightless Bird
Thank everyone very much for suggestions
Could you please give me any suggestions on how to add following condition
into batch file?
If (today is tuesday or wednesday or thursday or friday) and current time is
between 9 am to 10 am then
open D:/file.xls
Do you have any suggestions?
Thank everyone very much for any suggestions
Eric

"John John - MVP" wrote:

> Eric wrote:
> > Does anyone have any suggestions on how to code a batch file to open an excel
> > file if current time is between 9 am and 10 am? otherwise don't open it.
> > Thanks in advance for any suggestions
>
> Here you go:
>
> =======================================================================
> @echo off
> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
> if /i %tm% LSS 900 goto eof
> if /i %tm% GTR 1000 goto eof
> "x:/Data Folder\FileName.xls"
>
> =======================================================================
>
> John
> .
>
 
J

John John - MVP

Flightless Bird
Eric wrote:
> Thank everyone very much for suggestions
> Could you please give me any suggestions on how to add following condition
> into batch file?
> If (today is tuesday or wednesday or thursday or friday) and current time is
> between 9 am to 10 am then
> open D:/file.xls
> Do you have any suggestions?
> Thank everyone very much for any suggestions


If you only want to open a file on Friday and on no other day:

======================================================================
@echo off
for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
if /i %tm% LSS 900 goto eof
if /i %tm% GTR 1000 goto eof
if /i %day%==fri goto friday
goto :eof

:friday
"D:/file1.xls"

======================================================================



If you want to open different files based on day or the week:

======================================================================
@echo off
for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
if /i %tm% LSS 900 goto eof
if /i %tm% GTR 1400 goto eof
if /i %day%==sun goto sunday
if /i %day%==mon goto monday
if /i %day%==tue goto tuesday
if /i %day%==wed goto wednesday
if /i %day%==thu goto thursday
if /i %day%==fri goto friday
if /i %day%==sat goto saturday

:sunday
"D:/file1.xls"
goto :eof

:monday
"D:/file2.xls"
goto :eof

:tuesday
"D:/file3.xls"
goto :eof

:wednesday
"D:/file4.xls"
goto :eof

:thursday
"D:/file5.xls"
goto :eof

:friday
"D:/file6.xls"
goto:eof

:saturday
"D:/file7.xls"

======================================================================

John
 
J

John John - MVP

Flightless Bird
PS:

The command window will stay open (minimized to the taskbar). You can
use the START command to avoid this, example:

====================================================================
@echo off
for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
if /i %tm% LSS 900 goto eof
if /i %tm% GTR 1000 goto eof
if /i %day%==fri goto friday
goto :eof

:friday
start "C:/Program Files\Lotus\123\123w.exe" "E:/123DATA\PAYROLL.123"

=======================================================================

John


John John - MVP wrote:
> Eric wrote:
>> Thank everyone very much for suggestions
>> Could you please give me any suggestions on how to add following
>> condition into batch file?
>> If (today is tuesday or wednesday or thursday or friday) and current
>> time is between 9 am to 10 am then
>> open D:/file.xls
>> Do you have any suggestions?
>> Thank everyone very much for any suggestions
>
>
> If you only want to open a file on Friday and on no other day:
>
> ======================================================================
> @echo off
> for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
> if /i %tm% LSS 900 goto eof
> if /i %tm% GTR 1000 goto eof
> if /i %day%==fri goto friday
> goto :eof
>
> :friday
> "D:/file1.xls"
>
> ======================================================================
>
>
>
> If you want to open different files based on day or the week:
>
> ======================================================================
> @echo off
> for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
> if /i %tm% LSS 900 goto eof
> if /i %tm% GTR 1400 goto eof
> if /i %day%==sun goto sunday
> if /i %day%==mon goto monday
> if /i %day%==tue goto tuesday
> if /i %day%==wed goto wednesday
> if /i %day%==thu goto thursday
> if /i %day%==fri goto friday
> if /i %day%==sat goto saturday
>
> :sunday
> "D:/file1.xls"
> goto :eof
>
> :monday
> "D:/file2.xls"
> goto :eof
>
> :tuesday
> "D:/file3.xls"
> goto :eof
>
> :wednesday
> "D:/file4.xls"
> goto :eof
>
> :thursday
> "D:/file5.xls"
> goto :eof
>
> :friday
> "D:/file6.xls"
> goto:eof
>
> :saturday
> "D:/file7.xls"
>
> ======================================================================
>
> John
 
E

Eric

Flightless Bird
I finished the rest code on the other day, does it look right?
Thank everyone very much for any suggestions
Eric

======================================================================
@echo off
for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
if /i %tm% LSS 900 goto eof
if /i %tm% GTR 1000 goto eof
if /i %day%==tue goto tuesday
if /i %day%==wed goto wednesday
if /i %day%==thu goto thursday
if /i %day%==fri goto friday
goto :eof

:tuesday
:wednesday
:thursday
:friday
"D:/file1.xls"

======================================================================

"John John - MVP" wrote:

> Eric wrote:
> > Thank everyone very much for suggestions
> > Could you please give me any suggestions on how to add following condition
> > into batch file?
> > If (today is tuesday or wednesday or thursday or friday) and current time is
> > between 9 am to 10 am then
> > open D:/file.xls
> > Do you have any suggestions?
> > Thank everyone very much for any suggestions
>
>
> If you only want to open a file on Friday and on no other day:
>
> ======================================================================
> @echo off
> for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
> if /i %tm% LSS 900 goto eof
> if /i %tm% GTR 1000 goto eof
> if /i %day%==fri goto friday
> goto :eof
>
> :friday
> "D:/file1.xls"
>
> ======================================================================
>
>
>
> If you want to open different files based on day or the week:
>
> ======================================================================
> @echo off
> for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
> if /i %tm% LSS 900 goto eof
> if /i %tm% GTR 1400 goto eof
> if /i %day%==sun goto sunday
> if /i %day%==mon goto monday
> if /i %day%==tue goto tuesday
> if /i %day%==wed goto wednesday
> if /i %day%==thu goto thursday
> if /i %day%==fri goto friday
> if /i %day%==sat goto saturday
>
> :sunday
> "D:/file1.xls"
> goto :eof
>
> :monday
> "D:/file2.xls"
> goto :eof
>
> :tuesday
> "D:/file3.xls"
> goto :eof
>
> :wednesday
> "D:/file4.xls"
> goto :eof
>
> :thursday
> "D:/file5.xls"
> goto :eof
>
> :friday
> "D:/file6.xls"
> goto:eof
>
> :saturday
> "D:/file7.xls"
>
> ======================================================================
>
> John
> .
>
 
D

David H. Lipman

Flightless Bird
From: "Eric" <Eric@discussions.microsoft.com>

| Thank everyone very much for suggestions
| Could you please give me any suggestions on how to add following condition
| into batch file?
| If (today is tuesday or wednesday or thursday or friday) and current time is
| between 9 am to 10 am then
| open D:/file.xls
| Do you have any suggestions?
| Thank everyone very much for any suggestions
| Eric

Again...

Use the system Task Scheduler !

No programming logic needed -- KISS !


--
Dave
http://www.claymania.com/removal-trojan-adware.html
Multi-AV - http://www.pctipp.ch/downloads/dl/35905.asp
 
D

David H. Lipman

Flightless Bird
From: "Eric" <Eric@discussions.microsoft.com>

| I finished the rest code on the other day, does it look right?
| Thank everyone very much for any suggestions
| Eric

This is too funny...

Writing a BAT file for this is like swatting a fly with a sledge hammer.

The Task Scheduler is the easiest approach as *IT* will automatically do what you want at
a given time on a given day!


--
Dave
http://www.claymania.com/removal-trojan-adware.html
Multi-AV - http://www.pctipp.ch/downloads/dl/35905.asp
 
B

BillyBob

Flightless Bird
"David H. Lipman" <DLipman~nospam~@Verizon.Net> wrote in message
news:-OFCVMZUzKHA.4752@TK2MSFTNGP04.phx.gbl...
> From: "Eric" <Eric@discussions.microsoft.com>
>
> | I finished the rest code on the other day, does it look right?
> | Thank everyone very much for any suggestions
> | Eric
>
> This is too funny...
>
> Writing a BAT file for this is like swatting a fly with a sledge hammer.
>
> The Task Scheduler is the easiest approach as *IT* will automatically do
> what you want at
> a given time on a given day!
>
>
> --
> Dave
> http://www.claymania.com/removal-trojan-adware.html
> Multi-AV - http://www.pctipp.ch/downloads/dl/35905.asp
>

Dave,

Don't get yourself agitated. Eric is a moron that cannot follow simple
instructions. He multiposts all over the place. Read PA Bear's post above.
Check the microsoft.public.excel.programming NG and search 'Eric'.

Apparently, Eric has the mind of a houseplant and the mentality of a stepped
on potato chip. He needs his Thorazine dose increased dramatically or just
changed over to Risperdal. He'll post anything, anywhere as long as his
handcuffs are off. I know. I'm his doctor.

BB
 
P

Paul

Flightless Bird
David H. Lipman wrote:
> From: "Eric" <Eric@discussions.microsoft.com>
>
> | Thank everyone very much for suggestions
> | Could you please give me any suggestions on how to add following condition
> | into batch file?
> | If (today is tuesday or wednesday or thursday or friday) and current time is
> | between 9 am to 10 am then
> | open D:/file.xls
> | Do you have any suggestions?
> | Thank everyone very much for any suggestions
> | Eric
>
> Again...
>
> Use the system Task Scheduler !
>
> No programming logic needed -- KISS !
>
>

"KISS" even has its own article :)

http://en.wikipedia.org/wiki/KISS_principle

Paul
 
J

John John - MVP

Flightless Bird
David H. Lipman wrote:
> From: "Eric" <Eric@discussions.microsoft.com>
>
> | I finished the rest code on the other day, does it look right?
> | Thank everyone very much for any suggestions
> | Eric
>
> This is too funny...
>
> Writing a BAT file for this is like swatting a fly with a sledge hammer.
>
> The Task Scheduler is the easiest approach as *IT* will automatically do what you want at
> a given time on a given day!

But keep in mind that the scheduled task will run at the designated time
on the designated day whether you need to run it or not, and that it may
open files whether you want to work on them or not, or whether you are
at the computer or not. With the batch file you can run this at your
own time, like at 9:45 instead of 9:00, or not at all if there is
nothing to do with the file.

John
 
J

John John - MVP

Flightless Bird
Eric wrote:
> I finished the rest code on the other day, does it look right?

No, you put the labels :)tuesday, :wednesday...) but you didn't put any
commands under the labels (except for the :friday label) and you didn't
put a goto at the end of the labels so the batch file will keep on
processing down the list of labels regardless of the day of the week.
Also, being that you're opening the same file ("D:/file1.xls")
regardless of the day so you can shorten the batch file with one label
only, try this instead:


======================================================================
@echo off
for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
if /i %tm% LSS 900 goto eof
if /i %tm% GTR 1000 goto eof
if /i %day%==tue goto openfile
if /i %day%==wed goto openfile
if /i %day%==thu goto openfile
if /i %day%==fri goto openfile
goto :eof

:eek:penfile
"D:/file1.xls"

======================================================================

John
 
P

PA Bear [MS MVP]

Flightless Bird
BillyBob wrote:
>>> I finished the rest code on the other day, does it look right?
>>> Thank everyone very much for any suggestions
>>> Eric
>>
>> This is too funny...
>>
>> Writing a BAT file for this is like swatting a fly with a sledge hammer.
>>
>> The Task Scheduler is the easiest approach as *IT* will automatically do
>> what you want at
>> a given time on a given day!
>>
>
> Dave,
>
> Don't get yourself agitated. Eric is a moron that cannot follow simple
> instructions. He multiposts all over the place. Read PA Bear's post
> above.
> Check the microsoft.public.excel.programming NG and search 'Eric'.
>
> Apparently, Eric has the mind of a houseplant and the mentality of a
> stepped
> on potato chip. He needs his Thorazine dose increased dramatically or
> just
> changed over to Risperdal. He'll post anything, anywhere as long as his
> handcuffs are off. I know. I'm his doctor.

Screenwipes, please.

Paging Nurse Ratchet...
 
E

Eric

Flightless Bird
Thanks a lot for suggestions
Eric

"John John - MVP" wrote:

> Eric wrote:
> > I finished the rest code on the other day, does it look right?
>
> No, you put the labels :)tuesday, :wednesday...) but you didn't put any
> commands under the labels (except for the :friday label) and you didn't
> put a goto at the end of the labels so the batch file will keep on
> processing down the list of labels regardless of the day of the week.
> Also, being that you're opening the same file ("D:/file1.xls")
> regardless of the day so you can shorten the batch file with one label
> only, try this instead:
>
>
> ======================================================================
> @echo off
> for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
> if /i %tm% LSS 900 goto eof
> if /i %tm% GTR 1000 goto eof
> if /i %day%==tue goto openfile
> if /i %day%==wed goto openfile
> if /i %day%==thu goto openfile
> if /i %day%==fri goto openfile
> goto :eof
>
> :eek:penfile
> "D:/file1.xls"
>
> ======================================================================
>
> John
> .
>
 
B

BillyBob

Flightless Bird
"PA Bear [MS MVP]" <PABearMVP@gmail.com> wrote in message
news:-OVAEPPXzKHA.2436@TK2MSFTNGP04.phx.gbl...
> BillyBob wrote:
>>>> I finished the rest code on the other day, does it look right?
>>>> Thank everyone very much for any suggestions
>>>> Eric
>>>
>>> This is too funny...
>>>
>>> Writing a BAT file for this is like swatting a fly with a sledge hammer.
>>>
>>> The Task Scheduler is the easiest approach as *IT* will automatically do
>>> what you want at
>>> a given time on a given day!
>>>
>>
>> Dave,
>>
>> Don't get yourself agitated. Eric is a moron that cannot follow simple
>> instructions. He multiposts all over the place. Read PA Bear's post
>> above.
>> Check the microsoft.public.excel.programming NG and search 'Eric'.
>>
>> Apparently, Eric has the mind of a houseplant and the mentality of a
>> stepped
>> on potato chip. He needs his Thorazine dose increased dramatically or
>> just
>> changed over to Risperdal. He'll post anything, anywhere as long as his
>> handcuffs are off. I know. I'm his doctor.
>
> Screenwipes, please.
>
> Paging Nurse Ratchet...

LOL. FYI, she's my wife

Cheers,

R.P "BillyBob" McMurphy
 
D

David H. Lipman

Flightless Bird
From: "Paul" <nospam@needed.com>

| David H. Lipman wrote:
>> From: "Eric" <Eric@discussions.microsoft.com>

>> | Thank everyone very much for suggestions
>> | Could you please give me any suggestions on how to add following condition
>> | into batch file?
>> | If (today is tuesday or wednesday or thursday or friday) and current time is
>> | between 9 am to 10 am then
>> | open D:/file.xls
>> | Do you have any suggestions?
>> | Thank everyone very much for any suggestions
>> | Eric

>> Again...

>> Use the system Task Scheduler !

>> No programming logic needed -- KISS !



| "KISS" even has its own article :)

| http://en.wikipedia.org/wiki/KISS_principle

| Paul

:)

--
Dave
http://www.claymania.com/removal-trojan-adware.html
Multi-AV - http://www.pctipp.ch/downloads/dl/35905.asp
 
J

John John - MVP

Flightless Bird
You're welcome.

John

Eric wrote:
> Thanks a lot for suggestions
> Eric
>
> "John John - MVP" wrote:
>
>> Eric wrote:
>>> I finished the rest code on the other day, does it look right?
>> No, you put the labels :)tuesday, :wednesday...) but you didn't put any
>> commands under the labels (except for the :friday label) and you didn't
>> put a goto at the end of the labels so the batch file will keep on
>> processing down the list of labels regardless of the day of the week.
>> Also, being that you're opening the same file ("D:/file1.xls")
>> regardless of the day so you can shorten the batch file with one label
>> only, try this instead:
>>
>>
>> ======================================================================
>> @echo off
>> for /f "tokens=1 delims=/.- " %%A in ('echo %date%') do (set day=%%A)
>> for /f "tokens=1-2 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b)
>> if /i %tm% LSS 900 goto eof
>> if /i %tm% GTR 1000 goto eof
>> if /i %day%==tue goto openfile
>> if /i %day%==wed goto openfile
>> if /i %day%==thu goto openfile
>> if /i %day%==fri goto openfile
>> goto :eof
>>
>> :eek:penfile
>> "D:/file1.xls"
>>
>> ======================================================================
>>
>> John
>> .
>>
 
You must log in or register to reply here.
Top