batch file replace information

J

James

I was trying to setup a batch file (.bat or .cmd, etc.) to go into an excel cvs file and replace text. the cvs file will always be in the same directory but the file name will change. it will always have a date.csv name in the following format: mm-dd-yyyy.cvs. is it possible to do this?
 
D

Dave Peterson

If you want to run it like a bat file (not by loading excel and running a
macro), maybe you could use a Scripting file (.vbs).

But I'd ask the question in one of the newsgroups dedicated to scripting.

And I'd add some details--how to determine the filename (today's date???) and
what should be changed.
 

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

Windows 8 (cross-post from w2k forum) Running .bat files minimized from scheduler - in windows 8 (x64) ?? 0
using write #1 to create a batch file 2
International Date formatting 4
batch file call from a macro - how ? and required batch format 3
I want to run a batch file. Is there an easier way 2
Auto emailing of files 2
Date format error with CSV file 6
Insert Todays Date - 3 in file name 1

Top