batch file replace information
 

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?

batch file replace information
 

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.



James wrote:

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?

--

Dave Peterson