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

Top