LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
batch file call from a macro - how ? and required batch format VB-rookie Excel Programming 4 September 6th 08 12:52 AM
Replace information based on existing information brownti via OfficeKB.com Excel Programming 0 July 26th 07 04:03 PM
Would Like to Automate Batch File Creation and Text FIle Import socrtwo Excel Discussion (Misc queries) 2 August 18th 06 03:54 PM
Batch Replace function for Large strings R Avery[_2_] Excel Programming 4 March 28th 05 10:18 PM
Create a batch file from a number of Excel File Vinay[_2_] Excel Programming 0 September 8th 04 01:11 AM


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"