Creating a batch file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sufficiently familiar with batch files to write this but I would like
to create a .bat file that would:

1. open (hourly/daily) a real-time database called Pulse in directory
C:\Pulse\Pulse 8.3.5.1\Pulse.exe
2. save it as an htm file in d:\documents and settings\xzy094z\My
Documents\htm files
3 open this htm file with Excel and
4. save as .xls file in a given sub folder in a shared drive (e.g.
L:\documents and settings\daily reports\Monday) as, say '0900 Mon', '1000
Mon' etc etc

I would want this to run hourly and daily between 09:00 Monday and 22:00
Sunday, preferably deleting the htm file in My Docs folder before the next
hour's run to avoid any overwriting of data.

How would I produce the .bat file and what would be an example of the script
needed to perform the above?

Many thanks for your help!
 
Hello Zakynthos,

Better post this in microsoft.public.scripting or microsoft.public.windows.server.scripting

Best regards

myweb
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

batch files at logoff 3
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
How to write data into a xls sheet from batch file 0
How to create .pdf dummy files from .xls using batch file 1
recursive batch file 4
Create a batch file 2
Windows 8 (cross-post from w2k forum) Running .bat files minimized from scheduler - in windows 8 (x64) ?? 0
Quirky behaviour of batch file 2

Back
Top